If there is a space between the first and last name in the single column name wouldn't it be easier to use the Text to Columns command in the Data menu. Select the Delimited bullet; Go to the next screen & select the Space box; & then press finish in the next screen. Make sure that you leave an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.