Extracting values need help ASAP!!! :o)
 

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

Extracting values need help ASAP!!! :o)
 

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

You are going to kick yourself<g....

=RIGHT(A1,4)

Rick

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

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

Extracting values need help ASAP!!! :o)
 

Your right... I am kicking myself!!! :o) Thanks a million!!

"Rick Rothstein (MVP - VB)" 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??

You are going to kick yourself<g....

=RIGHT(A1,4)

Rick