Create static text from cell reference

  • Thread starter Thread starter Greg Casper
  • Start date Start date
G

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...
 
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.
 
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
 
Back
Top