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

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

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

April,

If you always have 4 numbers and the "C" in "VC" is constant then,

=MID(A1,FIND("C",A1,1)+1,4)*1



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561445

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

THANK YOU STEVE!!! THAT WORKED!!!!!!!!!!

"SteveG" wrote:


April,

If you always have 4 numbers and the "C" in "VC" is constant then,

=MID(A1,FIND("C",A1,1)+1,4)*1



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561445

April,

The formula I gave you won't return the "A" at the end of your string
without changing the 4 to a 5. Use this instead,

=RIGHT(A1,LEN(A1)-FIND("VC",A1,1)-1)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561445