Extracting values need help ASAP!!! :o)
If it is always the last four numbers
=--RIGHT(A1,4)
if it is what's after VC regardless of how many numbers there are
=--MID(A1,FIND("VC",A1)+2,255)
--
Regards,
Peo Sjoblom
"DestinySky" wrote in message
...
ok I have 000000VC3236 in a cell. How can I extract only the last 4
numbers,
3236?? I have tried =SUM(MID(A1,3,FIND("VC",A1)-3)) . What am I doing
wrong??
|