Create static text from cell reference

[Greg Casper]

Hey everyone...

I have two columns of text which I'm combining in a third column using the
formula (for C1, for example) =A1 & char(10) & B1

This gives me the contents of A1 on a line above the contents of B1 and
works fine.

What I NEED to do is somehow create column C as TEXT, not as a REFERENCED
data from columns A and B. How do I create a cell that contains the actual
TEXT content of another cell instead of a REFERENCE to the other cell?

TIA...

 

[Bob I]

Select all the cells in "C" that have content. R-click them and select
"Copy" then r-click again, select Paste Special, Values, then OK.

 

[Pete_UK]

Select C1 (or a group of cells in this column if you have more) and
click <copy>. Then click on Edit | Paste Special | Values (check) | OK
then <Esc>, You will now have the text in cell C1 rather than the
formula.

Hope this helps.

Pete