View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ket
 
Posts: n/a
Default Replace double spaces with Hard return

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