| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replacing commas with carriage return
Hi All,
I have a list of names like so: John Thomson, Paul Cooper, Ian Smith, Mark Devlin... and so on The names are in one continuous string i.e. they start from one cell (A1). I'd like to replace the commas with a carriage return to place each name into its own cell. Is there function or calculation I can use to achieve this? Any advise would be appreciated. TIA - H |
| 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 | |||
| Search and replace with Carriage return | Excel Discussion (Misc queries) | |||
| How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
| Carriage Return in Excel | Excel Discussion (Misc queries) | |||
| Carriage return in macros | Excel Worksheet Functions | |||
Threaded Mode
