Line breaks in my cells...
If it is Alt-Enter [CHAR(10)] that you are trying to replace, type Control-J
into the Replace: "Find what" box.
--
David Biddulph
"AkelA" wrote in message
...
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
*******s. The table contains over 6000 records, so I may not want to go
cell-by-cell manually. Can you please help?
Thx, brgd!
|