| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate last name from a cell with full name
Cell A1 has "John Doe", what formula can use to get the last name only in
cell B1? -- Thanks, Ty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate last name from a cell with full name
Try this...
=MID(A1,FIND(" ",A1)+1,50) -- Biff Microsoft Excel MVP "Ty" wrote in message ... Cell A1 has "John Doe", what formula can use to get the last name only in cell B1? -- Thanks, Ty |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate last name from a cell with full name
Assuming the cell only has a first and last name, you can use:
=MID(A1,FIND(" ",A1)+1,999) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ty" wrote: Cell A1 has "John Doe", what formula can use to get the last name only in cell B1? -- Thanks, Ty |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate last name from a cell with full name
Perfect
-- Thanks, Ty "Luke M" wrote: Assuming the cell only has a first and last name, you can use: =MID(A1,FIND(" ",A1)+1,999) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ty" wrote: Cell A1 has "John Doe", what formula can use to get the last name only in cell B1? -- Thanks, Ty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have seperate headers for seperate pages in 1 worksheet? | Excel Discussion (Misc queries) | |||
| seperate a full name into first, middle, last, & suffix column | Excel Worksheet Functions | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
Hybrid Mode
