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