Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My imported "Name" column (column A) contains different name formats: First
Name Last Name; First Name Middle Initial Last Name; and, in some cases, First Name Middle Name Last Name (for example: Mary Smith, John B. Doe, William James Burrows). Is there a simple way to convert all names to three columns with the Given Name in Column B, the Middle Initial or Name in Column C, and the last name in Column D? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find a text from a column in a text string within another column? | New Users to Excel | |||
complicated multi column formula help | Excel Discussion (Misc queries) | |||
Forming a binary column from a more complicated column of diagnostic codes | Excel Discussion (Misc queries) | |||
Complicated extraction of text | Excel Discussion (Misc queries) | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) |