//some 3rd party need geo

excel / vba - I want text from string until number

  Heefie 11:05 31 Dec 04
Locked

I know I can do this in a long-winded way, with a few lefts and rights and len statements, I'm just wondering if there's a shorter way ...

I have a number of records that begin with a character string & end with a number, as in :

ABC6


ABCDEFG9


ABCD23


ABCDEFGHI6


... is there a simple expression / formula that I can use to extract JUST the Alpha string from the start ?!?!

Cheers in advance for any help ...

  pc moron 16:38 31 Dec 04

This does the job:

=LEFT(A1,MIN(IF(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},A1)),FIND({1,2,3,4,5,6,7,8,9,0},A1)))-1)

For ref 6th post here click here

  Heefie 01:32 01 Jan 05

That works fine, but I needed it to work in VBA, so I've sorted it now ...

This thread is now locked and can not be replied to.

What is Google Allo? What is Google Duo? Google Allo UK release date rumours and features: Google…

1995-2015: How technology has changed the world in 20 years

These clever designs help visualise a complex intelligence tool

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…