Extracting values need help ASAP!!! :o)
If the numbers are always at the end and 4 digits:
=RIGHT(A1,4)
or if always preceded by "VC"
=MID(A1,FIND("VC",A1)+2,255)
"DestinySky" wrote:
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??
|