Line break
 

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

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

Line break
 

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?