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

[Guest]

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

 

[Don Guillett]

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

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

 

[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)

 

[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.

 

[Don Guillett]

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

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