Excel 2010 Column heading has three rows in one cell. Make one row.

How can I get the three rows (lines) within an Excel cell to be just one row (line)?  I have several columns formatted that way.  Is there a function to do this?
LVL 7
tomfarrarAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Martin LissConnect With a Mentor Older than dirtCommented:
I found this on the web.

If you want to replace these line-breaks with for example a space, you can do this with Excel's find/replace command. In the "Find what:" box you can enter the line-break code, which is character number 10. To do this, press and hold the Alt key, and then enter the numbers 010 from the numeric part of the keyboard.
0
 
Martin LissOlder than dirtCommented:
You can Format Cells->Alignment-Merge Cells, but that will delete the content of 2 of the 3 rows. You can add the data back afterward.
0
 
tomfarrarAuthor Commented:
Can you find/replace on a line break?  The clean function makes it one line, but without spaces between words.
0
 
tomfarrarAuthor Commented:
Thanks, Martin, that does work. Though when you use the ALT button and enter 010, nothing shows up in the Find Box. But if you proceed on to the Replace and enter a space the Find/Replace works. Thanks again.
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2015
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.