Extracting numbers until i reach a letter

[Kaypea]

Hi,

I work with references that look like this 38293883M34D345 or 07586A484T45. there is a mixture of letters and numbers. i would like to have a formula that will only pick up the numbers before the first letter regardless of how many numbers there are. Like the 38293883 or 07586 from those references.

We receive a spreadsheet with these references on and only need the first set off numbers before the first letter. I have tried a couple of formulas and they seem to still include the letter and some numbers after.

I dont have access to VBA to use at my place of work. I am a novice in regards to excel but try and make my life easier. Please could someone assist with this?

Thank you

 

[sxhall]

=LEFT(A1,MATCH(TRUE,ISERROR(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),0)-1)

 

[Phuoc]

Or try this:

=LET(letters, CHAR(SEQUENCE(26, , 65)), TEXTBEFORE(A2&"A", letters))

 

[Kaypea]

They both work very well. thank you very much

 

[Scott Huish]

A shorter version of Phuoc's

=TEXTBEFORE(A2&"A", CHAR(SEQUENCE(26, , 65)))