Solved

Remove characters in a cell reference

Posted on 2011-09-21
3
153 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 81

Accepted Solution

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

Expert Comment

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

Author Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
consolidate from multiple folders 5 39
Formula 6 46
Freeze Panes Solution 6 28
Automating Excel Weekly Report 13 59
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 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

14 Experts available now in Live!

Get 1:1 Help Now