Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract first name only from full name
I have a cell that contains last name, first name. I would like to extract
the first name and put in seperate cell. As an example if A1 = Smith John I would like to have A2 = John and A3 = Smith Please advise. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ctrl+Alt+F9 not performing Full Recalculation on some PCs | Excel Worksheet Functions | |||
Trendline Extract | Charts and Charting in Excel | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Worksheet won't display full screen | New Users to Excel | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) |