Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find replace text or symbol with carriage return | New Users to Excel | |||
How do I make a hard return within a cell in Excel? | New Users to Excel | |||
How do I insert a "hard return" in a cell? | Excel Discussion (Misc queries) | |||
Is is possible to add a hard return to a merge cell formula? | Excel Discussion (Misc queries) | |||
hard return | New Users to Excel |