Extracting data from a cell
 

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

Extracting data from a cell
 

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

Extracting data from a cell
 

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