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