April,

If there are always 5 characters, you could set up a temp column with the
following formula in the first cell.
=RIGHT(A1,5)
Where A1 is the cell with "000000VC38734" in it. Then drag it down for
remaining rows. You could then copy the results and Paste/Special/Vaules
over the original data if you wish and delete the temp column.


"April Stallings" wrote:

I have a cell that has 000000VC3873A in it. All I need are the numbers to the
right of the VC. How can I do this. Someone here helped me awhile back with a
similar problem, but that formula will not help me here! Does anyone have an
idea??

Thanks so much!!
April