find first letters in a string of alphanumerics

[zpierucci]

I have a string ex: ".13 - LAR"

I would like to get the first letters, or non alphanumeric and non numeric characters of the string. They are not always the same distance from the beginning so I can't use left or right function. However they always begin in the 6th or 7th position.

Any thoughts?

 

[Scott Huish]

Is it always after the last space?

 

[DanteAmor]

Is there always a hyphen between numbers and text?

 

[igold]

If it's always going to be three letters then how about this for a string that is in Cell A1...

=IF(OR(AND(CODE(MID(A1,6,1))>64,CODE(MID(A1,6,1))<91),AND(CODE(MID(A1,6,1))>96,CODE(MID(A1,6,1)<123))),MID(A1,6,3),MID(A1,7,3))

 

[Scott Huish]

Just for finding the string starting with a letter:
=MID(A1,MIN(FIND(CHAR(ROW(INDIRECT("65:90"))),A1&"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))-1,255)

or finding the string after the last space:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))

 

[Peter_SSs]

If your question has not been answered by any of the suggestions so far, what about giving us a variety of sample data and the expected results.
One example makes it hard for helpers who then have to try and guess the logic for your other data that we haven't seen.

 

[zpierucci]

yes it is

 

[zpierucci]

Yes

 

[igold]

It would be nice to know what you are saying "Yes" to.

 

[zpierucci]

Sorry. Yes, it is always a hyphen between numbers and texts