Extracting data from a cell

A

April Stallings

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
 
M

MDubbelboer

not the most eloquent, but it'll work and will be easy for you t
modify if needed

assuming your cell is in A1,
=RIGHT(A1,LEN(A1)-FIND("VC",A1,1)-1)
 
Top