Break up single column with Users and Phone numbers in Excel

I have a single column with name and number formatted like... "Joe Smith972-555-1212" (no space between name and number). How would I break that into 2 columns, 1 name and 1 number?

Thanks.
RickzzzAsked:
Who is Participating?
 
ProfessorJimJamCommented:
put this in one cell =LEFT(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))-1)

and in another =RIGHT(A2,LEN(A2)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))+1)
0
 
RickzzzAuthor Commented:
Perfect, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.