Line breaks in my cells...

[Guest]

Hello!

I received an excel worksheet that contains "line break" characters in some
of the cells and they cause me a lot of trouble. How do I eliminate them? I
tried "Find and Replace..." but I cannot search for these tricky little
bastards. The table contains over 6000 records, so I may not want to go
cell-by-cell manually. Can you please help?

Thx, brgd!

 

[David Biddulph]

If it is Alt-Enter [CHAR(10)] that you are trying to replace, type Control-J
into the Replace: "Find what" box.

 

[Guest]

Do you mean "^j"? I have a non-English version and Ctrl+J does not do
anything... For "^J" Excel returned no results.

Anyway, I managed to solve my problem with a little trick, but still I would
like to know. For future problems like this..... Btw, where can I find
reference for these special characters?

If it is Alt-Enter [CHAR(10)] that you are trying to replace, type Control-J
into the Replace: "Find what" box.
--
David Biddulph

Hello!

I received an excel worksheet that contains "line break" characters in
some
of the cells and they cause me a lot of trouble. How do I eliminate them?
I
tried "Find and Replace..." but I cannot search for these tricky little
bastards. The table contains over 6000 records, so I may not want to go
cell-by-cell manually. Can you please help?

Thx, brgd!

 

[Gord Dibben]

Try Alt + 0010 in the Find what dialog.

Use the NumPad to enter the 0010

To see which characters you have in a cell, download Chip Pearson's CellView
add-in.

http://www.cpearson.com/excel/CellView.htm



Gord Dibben MS Excel MVP