[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

Remove characters in a cell reference

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 =
Joe Smith
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?

Thank you.
0
thandel
Asked:
thandel
  • 2
1 Solution
 
byundtCommented:
Did you turn Wrap Text on in the target cell (the one with the OFFSET formula)?
0
 
byundtCommented:
In Excel 2003, the Wrap Text checkbox is found in Format...Cells...Alignment menu item.
0
 
thandelAuthor Commented:
Ah that was it... didn't even think of that... thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now