Hi,

Is there a function in Excel 365 similar to "=value()" but for text in order to extract the pure text from a cell? As an example, I have used "=transpose()" on a dataset. I wish to extract the text from the transposed data to another column to carry on working on the dataset. Is there a way of doing this?