Hi all... I have made a formula which I have made onto some columns... How do now convert the text from the formula into normal text, if that makes sense?
Hi all... I have made a formula which I have made onto some columns... How do now convert the text from the formula into normal text, if that makes sense?
Not sure what you mean. However, you can put an apostophe in front of the formula, or, you may copy everything except the "=".
Ben Van Johnson
Sorry yea I didn't explain at all... Ok so I have all this data in one column, in the next column along I have made some formulas that format the data in the previous column how I like it... But now I have 2 columns with the same data, BUT the one on the right has the right formatting, if I delete the left column obviously there is no data for the formulas to work so the right column doesn't work... So I have seen previously that you can convert converted formula data just into normal text... Just can't remember how to do it...
How about copying the column with the correct data in, then pasting it using paste-special-values over the top?
That would give you the results of the formulas and not affect the formatting, it gets rid of the formulas and just puts the results in the cells
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks