I used ALT+ENTER to enter line-breaks within a cell.

Now, is there a way to eliminate leading spaces from the lines?

Hi again Gary,

Gord Dibben pointed out an error in my previous post. Here it is corrected.
The leading spaces is what I referred to when I said that you might have to
enter comma and a space in the find section.

In Replace dialog box, insert a comma in Find what (Might need comma plus a
space if you have a space after the comma otherwise you will have a leading
space on the next line.)

In Replace with, Alt +0010 or Ctrl+J . (You won't see anything)
and then Replace all.

Repeat for semi colon.

If you want to retain the comma/semicolon, then simply include it in the
replace with.


Regards,

OssieMac


"GARY" wrote:

I used ALT+ENTER to enter line-breaks within a cell.

Now, is there a way to eliminate leading spaces from the lines?