No problem Thomas, I did not mean to sound critical..........I'm glad you got
it working. Please don't hesitate to come back if we can be of any further
assistance.

Vaya con Dios,
Chuck, CABGx3



"T Miller" wrote:

CLR,

Very true sir,

I did not relize this until I got the error's. I did get it to work though,
now I just need to combine some rules and statements to make it work as one.
Thanks to all for the help, this was a learning one for me and now I know how
it works.
--
Thomas


"CLR" wrote:

There has to be some consistancy in the data in order to write rules into
formulas to allow Excel to extract the desired parts. All of your samples
showed the cells ending in EA, and now you say they all don't........perhaps
if you would give a larger sample of your data, more representative of the
extremes, it would help.

Vaya con Dios,
Chuck, CABGx3



"T Miller" wrote:

No, it could have cs, pk, etc also, what can you use other than listing them
all out in the IF statement?
--
Thomas


"JE McGimpsey" wrote:

Will there always be "EA" at the end of the string? If so

=IF(A2="EA", 1, --TRIM(MID(LEFT(A2, LEN(A2) - 2), FIND("%",
SUBSTITUTE(A2,"/","%", LEN(A2) - LEN(SUBSTITUTE(A2,"/",""))))+1, 255)))

appears to work...


In article ,
T Miller wrote:

I need to remove a value in a cell and place only that value in the next
cell, example:

Column One Column Two
CS/4 BX/40 EA 40
CS/72 EA 72
EA 1

Is there an IF statement that can do this? I have 1200 rows of these and I
need to just have the last number in column two and where there is text(EA) I
need it to show the number 1? Can this be done?