| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last"
THANKS A LOT. You don't know how much you helped. I am a recruiter and I just
shared your helpful information to hundreds of other recruiters. "Teethless mama" wrote: Data Text to Columns Delimited Finish "JBird11002" wrote: Make formatted name in one column from "last, first MI" to three seperate columns of: 1st col-First name"first", 2nd col-Middle"middleOrMI" and 3rd col-Last name"last". When you have a file with several rows of names you would like to do this to, how do you do it? Going through it individual row by row would be time consuming and monotonous. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Threaded Mode
