Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get the middle name
how can i get the middle name of "fazain iqbal khan"... i can get the last
name by =(a2,len(a2)-search("#", substitute(a2&" "," ","#",2)))... and first name=right(a2,find(" ",a2)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
First name, Middle Initial | Excel Discussion (Misc queries) | |||
Trying to freeze panes. line down and through middle of worksheet. | Excel Worksheet Functions | |||
Stripping Middle Initial from a Name | Excel Worksheet Functions | |||
Marcro recroding/ stop Ikon not appearing in middle of excel sheet | Excel Discussion (Misc queries) |