Extracting data
 

I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How
can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What
am I doing wrong??

Extracting data
 

On Aug 13, 12:08 pm, DestinySky
wrote:
I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How
can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What
am I doing wrong??

You're on the right track. I would use =MID(A1,FIND("VC",A1)+2,4)

..o.

Extracting data
 

You have answers to your early (< 10 minutes ago) posting: be patient!

"DestinySky" wrote:

I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How
can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What
am I doing wrong??

Extracting data
 

Not sure why you're using the SUM function, but otherwise you were close.
Try this:

=MID(A1,FIND("VC",A1)+2,99)

HTH,
Elkar


"DestinySky" wrote:

I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How
can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What
am I doing wrong??

Extracting data
 

=right(A1,4) as text
=--right(A1,4) if you want it as a number
--
David Biddulph

"DestinySky" wrote in message
...
I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236.
How
can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) .
What
am I doing wrong??