Line break

G

GARY

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

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top