Extracting data

D

DestinySky

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??
 
O

omnicrondelicious

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??
Click to expand...

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

..o.
 
E

Elkar

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
 
Top