Cell A1 has "John Doe", what formula can use to get the last name only in cell B1?
T Ty Nov 3, 2009 #1 Cell A1 has "John Doe", what formula can use to get the last name only in cell B1?
L Luke M Nov 3, 2009 #3 Assuming the cell only has a first and last name, you can use: =MID(A1,FIND(" ",A1)+1,999)
T Ty Nov 3, 2009 #4 Perfect -- Thanks, Ty Luke M said: 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!* Click to expand...
Perfect -- Thanks, Ty Luke M said: 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!* Click to expand...
