Remove characters in a cell reference
Posted on 2011-09-21
Excel 2003. I have a cell that contains a line feed (persons name and address) in a single cell but there are "4" line entries in the cell: Ex: Cell A7 =
123 Gold St
Nowhere CT, 12345
I then have an offset in another cell to referce cell A7. All is working ok but when I use the offset instead of getting a cell with multipul lines they are all combine in a single line. The line break appears to have been replaced with another chratacter ,looks like a box.
How can I reference cell A7 with an offset but maintain the line breaks?