Pulling Number from Text String

[sbeatty]

Good morning all,

I am wondering the easiest way to pull a number from a column where the cells will be given an identifier number in addition to the name.

For example,

[10-001 Customer Name] Normally I would do a left function, but my department is starting to see more instances of [10-1000 Customer Name] and we're expecting to see [10-10000 Customer Name] in the future.

I'm wondering if it's possible to do some sort of TRIM(SUBSTITUTE("-","",) etc. to get the "-" symbol in the ID to pull just the numeric values, but I'm not sure how to extract that value from a text string.

Any leads?


Thanks!!
Scott

[Raphaelp]

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

[sbeatty]

Yep that totally works! Thanks - never used FIND before.

[Glenn Kennedy]

In the case of your samples - what is your expected result???