| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell
Hi All
I have a list of names which includes the Surname and First Name (with a space in the middle). Is it possible to split the list into two (one column for the first name and one for the Surname). As you would expect the names are all different lengths so I guess to need a command to split where ever there is a space. Any help greatly appreciated Kind regards Rexmann (using excel 2002) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
| Split a cell | Excel Discussion (Misc queries) | |||
| Split cell help! | Excel Discussion (Misc queries) | |||
| How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) | |||
| Is there a way I can split last name first name in one cell | Excel Discussion (Misc queries) | |||
Threaded Mode
