Solved

Remove characters in a cell reference

Posted on 2011-09-21
3
152 Views
Last Modified: 2012-05-12
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
Comment
Question by:thandel
  • 2
3 Comments
 
LVL 80

Accepted Solution

by:
byundt earned 500 total points
Comment Utility
Did you turn Wrap Text on in the target cell (the one with the OFFSET formula)?
0
 
LVL 80

Expert Comment

by:byundt
Comment Utility
In Excel 2003, the Wrap Text checkbox is found in Format...Cells...Alignment menu item.
0
 

Author Comment

by:thandel
Comment Utility
Ah that was it... didn't even think of that... thanks!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now