| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting data into multiple fields.
I need to split a name field in a column that contains one or all of the
following components without consistency: courtesy title (i.e. Mr.), First Name, Middle Inital and Last Name. Some examples of records in my column a Mr. K. Kyle Mathis Ms. Terri Mathis Ms. Ellen E. Vallatini Cole Vallatini Nick A. Vallatini I tried using the command "Data" "Text to Columns" but, with the inconsitency in data, it split correctly in some place but incorrectly in others. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding multiple data fields from time based data. | Excel Discussion (Misc queries) | |||
| Splitting Column Data into 2 fields | Excel Worksheet Functions | |||
| splitting fields | Excel Discussion (Misc queries) | |||
| splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
| Pivot Tables multiple data fields | Excel Worksheet Functions | |||
Threaded Mode
