Mid Function with Find

  • Thread starter Thread starter John T. Riordan
  • Start date Start date
J

John T. Riordan

Hello,
I am trying to extract part of a text string made up of a
bunch of numbers with some alphanumeric characters [a to
z] in the middle.

I was planning to use the =Mid(A2, Find([a-z],A2),255)
formula, but Excel doesn't like the wildcard [a-z] that
Access uses. Likewise Access doesn't have the Find
function to use with its Mid function.

Does anyone know how to find any alpha character within a
bunch of numbers and symbols (+, -, space, etc.)?

Thanks for your help in advance,
John T. Riordan
Trett Consulting B.V.
 
To get the position of the first non numeric character try

=MATCH(FALSE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0)

entered with ctrl + shift & enter
 
Back
Top