How to trim number of varying length from front of text string

[megera716]

I have item names out of my accounting system with a number at the front that denotes the month that the item became available (I have a separate column for the year). The item names are varying lengths and the leading numbers are too because if it comes out in May, the number is 5, but if it comes out in October, the number is 10.

Like so:
5 Widget
5 Different Widget
5 Another Widget
10 New Widget
10 Improved Widget

I want to get the month number into its own column. I have months 1-12 so I can't just write a formula to say if it's a 5 or a 10, do X. It would be exceedingly difficult to change the item names with a single digit (1-9) to 01-09 so that they would be the same number of characters as the two-digit months.

Thanks in advance for your help!

 

[Rick Rothstein]

For the number...

=0+LEFT(A1,FIND(" ",A1)-1)

For the text...

=MID(A1,FIND(" ",A1)+1,LEN(A1))

 

[Joe4]

To get the number before the first space, you can just use this:

=LEFT(A1,FIND(" ",A1)-1)+0

Edit: Looks like I am just a tick slower than Rick today!

 

[JLGWhiz]

When a user looks at the item names now, how do they determine which is a one digit or two digit month? ie. What tells that user where the widget part of the number begins?

 

[Rick Rothstein]

Edit: Looks like I am just a tick slower than Rick today!

What can I say... you snooze, you lose.

 

[megera716]

For the number...

=0+LEFT(A1,FIND(" ",A1)-1)

For the text...

=MID(A1,FIND(" ",A1)+1,LEN(A1))

Thank you, this worked perfectly!! I love learning new formulas

 

[Joe4]

What can I say... you snooze, you lose.

That would be the shortest nap I have ever had (less than a minute!).
Dang my poor typing skills!

 

[Rick Rothstein]

That would be the shortest nap I have ever had (less than a minute!).

I know, I noticed that... that was the reason for the big giant grin.

 

[István Hirsch]

For the number:

=LEFT(A1,2)+0

 

[Rick Rothstein]

For the number:

=LEFT(A1,2)+0

What if the leading number is three or more digits long?