| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Stripping Middle Initial from a Name
Hello.
I need a function that strips the Middle Initial of a name. The names on my spreadsheet are all mixed up with names that have middle initials, and some that done. For example, I would like to strip the middle initial, 'X' off this name, "Doe, John, X", where Doe=last name, John=First Name, X=Middle Initial Hope that makes sense. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
| Marcro recroding/ stop Ikon not appearing in middle of excel sheet | Excel Discussion (Misc queries) | |||
| Extract middle initial | Excel Discussion (Misc queries) | |||
| How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
| Extracting Last Name and First Initial | New Users to Excel | |||
Threaded Mode
