April 9, 2024
Click here to learn more 💡
May 10, 2024
HansV MVP - Ashish Mathur - Andreas Killer - Jim_ Gordon - Riny_van_Eekelen ✅
Ask a new question
If you are only going to split into 2 cells then you could put this formula in the first cell to return the [John] part:
=LEFT(A1,FIND(" ",A1,1)-1)
and this formula in the next cell to return the right-hand part
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
269 people found this reply helpful
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
Thanks for your feedback.