000000VC7080 I need to look like 7080
000000VC3940A I need to look like 3940A
Basically I am needing the last 4 to 5 characters only NO zeros

"starguy" wrote:


do you want to put zeros on the right of VC? please put another example
of data.

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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=561445