Hi MSP,

I will again suggest if you have only "first name" and "last name" in your data (as your example shows), go for Text - to - column feature of excel. select the data and press Alt + D + E key combination and you'll get the Text To column window where you can choose the Delimited option and on the next window, choose Space as delimiter.

@ MarvinP, I do not have any concern and can handle these types of formula demanding queries very easily but just wanted to show the "easy" and quick way to user as per the example shared by him. Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>