Extracting data

[Guest]

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

 

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

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

..o.

 

[Guest]

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

 

[Guest]

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

 

[David Biddulph]

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