Determine and separate numbers from a string!

[calibandog]

Have a schedule which has a few thousand lines like the following:

033 Masonry
0331 Brick and block construction
0332 Stone masonry
0333 Stone repair


with number lengths varying in each string . . . but always at the beginning of the string.

Issue:

I want to separate the numerical values from the string and place in an adjacent column . . . . retaining the text string as is!

calibandog

[alansidman]

Assume your data in column A. In B type =LEFT(A1,FIND(" ",A1)) and copy down.

[calibandog]

alansiman

Thank you! That was perfect for the numerical values.

In addition, I need to remove the numerical value from the string leaving only residual text!!! ))

Sorry . . . my request was not clear in that regard!

Regards

calibandog

[Alf]

Modifying alansidmans solution to meet your new request you could try =MID(A1,LEN(LEFT(A1,FIND(" ",A1))),LEN(A1)-LEN(LEFT(A1,FIND(" ",A1)))+1)

Alf

[FDibbins]

or add to it....

=SUBSTITUTE(A1,LEFT(A1,FIND(" ",A1)),"")