a1= 876/321 formula to pull only 321 from a1

N

NICK

i WANT TO USE THE SAME FORMULA THAT WILL DO THE FOLLOWING: PULL ONLY 321 FROM
876/321 OR PULL 44 FROM A CELL CONTAINING 876/44 OR PULL 5 FROM A CELL
CONTAINING 87654/5 BASICALLY EVERY TO THE RIGHT OF THE / SYMBOL
 
D

Don Guillett

1st. Please don't SHOUT by using all caps. It is considered very BAD
netiquette.

=RIGHT(I4,FIND("/",I4)-1)
 
F

Frank Kabel

Hi
first: please turn off your CAPS Lock: makes it difficult to read and
is considered as shouting in newsgroups.

For your question try:
=MID(A1,FIND("/",A1)+1,1024)
 
M

Myrna Larson

Hi, Don.

I think you are remembering the arithmetic for the LEFT function.

If the slash is the first character, your formula returns 0 characters from
the right end. You either need to subtract that position from the length, or
use MID.
 
D

Don Guillett

You are correct. I just tested with the 1st example. Could be

=RIGHT(I4,LEN(I4)-FIND("/",I4))
 
Top