John,

Thanks for your prompt reply. Another teaser for you. If there are an
unknown number of spaces between the last name and first name. Is
there a way of searching for any spaces greater than 2 and placing the
hard retrun just in front of the next first name?

Hope this makes sense.




On 26 Jun 2006 06:46:55 -0700, "John Michl"
wrote:

Ket -

· Highlight the column that you want to change.
· Press Ctrl-H to bring up the Find/Replace dialog box
· In the Find What box, press space bar twice
· In the Replace With box, hold down the Alt key and type 0010 on the
number pad (NOTE: You will not see anything entered in the Replace With
box.)
· Click Replace All and you should be done.

- John Michl



Ket wrote:
Hello,

I am using Excel 2003. I have a column of names, format first name
last name.
After each last name there are two spaces and then there is another
first name last name.
This carries on in most of the cells in the column.
Is it possible to replace the double space with a hard return?

Thanks in advance for your help.

Ket
London,UK