excel / vba - I want text from string until number

  Heefie 11:05 31 Dec 2004

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 :





... 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 2004

This does the job:


For ref 6th post here click here

  Heefie 01:32 01 Jan 2005

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.

Elsewhere on IDG sites

Samsung Galaxy S9 review

Wacom Cintiq Pro 24 and 32 review – hands-on

When is the next Apple event?

Les meilleures séries Amazon Prime Video (2018)