Split a cell

[jbodel]

I have cells that contain either a three digit, four digit or five digit number followed by a name. How can you split that cell (without using text to columns) so that in one new cell it contains the number and the next column it says the name. I am still a newbie to excel

thanks

 

[Fluff]

Is there a space or something else that separates the number from the name?

 

[jbodel]

Yes, there is a space between the number and the text

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

In that case how about

=LEFT(A2,FIND(" ",A2)-1)

and

=MID(A2,FIND(" ",A2)+1,100)

 

[jbodel]

Oh my gosh. Thank you so much. I will update my profile later, but thank you so much. YOu have made my co-worker and I very happy. Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.