IF and Right Functions
WOW! Thank you for your quick response to my question. It works like a champ.
Can you give me a break-down of the formula you gave?
Thank you, thank you, thank you!
Elaine
"Mike H" wrote:
Hi,
Try this for a string in a1 and drag down
=MID(A1,FIND("^^",SUBSTITUTE(A1,"-","^^",LEN(""&A1)-LEN(SUBSTITUTE(A1,"-",""))))+1,1024)
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Elaine" wrote:
Hello,
I have part #'s that end in 3 or 4 characters, some with a space. I would
like to display the last 3 or 4 characters in another column. I tried using
the IF and Right functions and have not solved it. I thank you in advanced
for your help on this formula.
Example:
Part # New Column (Result)
30-179-TC1 TC1
30-181-T C2 T C2
30-185-TC23 TC23
|