| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Splitting a cell, with a twist!
Hi,
I have data (names) which appear with Surname first, with all other names after that. (all in one cell). For example: Earles Prof Stanley William Edward What I want to do, is split this so that the first word (in this case "Earles" stays, and the rest is shifted into a new column. Any ideas? PS...I cant get Data, text to columns to work! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
