|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com