EXTRACTING the first four consecutive numbers and placing them in another cell?

**Robo** · 08-18-2009, 06:24 AM

Basically, column C is the tricky one. It comes from the bank and somewhere in there is a 4-digit tenant reference. I did a formula to try and isloate it and it worked on most but if you look at the very first row, there is a spurious 99 in there, so it didn't work. Is there a way of EXTRACTING the first four consecutive numbers and placing them in another cell?
Thanks
Robo

**DonkeyOte** · 08-18-2009, 06:30 AM

Are you able to install morefunc.xll ? This would allow you to use the Regex functions without need for a) UDF or b) complex formulae, eg using the morefunc REGEX.MID function:

H2: =REGEX.MID(A1,("[0-9]{4})")
copied down

Let us know...

re: morefunc:

Info: http://xcell05.free.fr/morefunc/english/
download: http://download.cnet.com/Morefunc/30...-10423159.html

**Robo** · 08-18-2009, 06:31 AM

Hi
No, our it dept wouldnt allow!

Robo

**DonkeyOte** · 08-18-2009, 06:33 AM

Hmmm... "computer says no" ... are you able to use VBA at all ?

**Robo** · 08-18-2009, 06:35 AM

Yes we can

**Robo** · 08-18-2009, 06:36 AM

what is morefunc.xll?

EXTRACTING the first four consecutive numbers and placing them in another cell?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

EXTRACTING the first four consecutive numbers and placing them in another cell?

Re: EXTRACTING the first four consecutive numbers and placing them in another cell?

Re: EXTRACTING the first four consecutive numbers and placing them in another cell?

Re: EXTRACTING the first four consecutive numbers and placing them in another cell?

Re: EXTRACTING the first four consecutive numbers and placing them in another cell?

Re: EXTRACTING the first four consecutive numbers and placing them in another cell?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions