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

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

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

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


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=561454

You replied to another thread that you had the solution.

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

--

Dave Peterson