1 to 3 number digit pull (=left(???))

[psrs0810]

How can I pull a list of numbers that vary from 1 to 3 digits? I was using =left, but kept modifing it for the varying digits

e.g.

I have I need
1-abc 1
23-apple 23
456-tree 456

 

[MrKowz]

Will there always be a dash indicating the end of the number? If so, try:

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

 

[sahild05]

=left(a1,find("-",a1)-1)

 

[Aladin Akyurek]

How can I pull a list of numbers that vary from 1 to 3 digits? I was using =left, but kept modifing it for the varying digits

e.g.

I have I need
1-abc 1
23-apple 23
456-tree 456

Try...

B2:

Either...

=LEFT(A2,FIND("-",A2&"-")-1)+0

Or...

=IF(A2="","",LEFT(A2,FIND("-",A2&"-")-1)+0)

 

[psrs0810]

thanks

 

[Aladin Akyurek]

thanks

You are welcome. Thanks for providing us feedback.