Formula

[Steved]

Hello From Steved

1. 3x343 Halo (10) 5g ch
2. 4335 Te Maika (3) 4g b

With the above is it possible to have a formula
to delete and leave what's below

Halo
Te Maika

Thankyou.

 

[Jerry W. Lewis]

What is your criteria for identifying what to keep?

=IF(ISNUMBER(FIND(" ",A1,4))*ISNUMBER(FIND("(",A1)),IF(FIND("
",A1,4)<FIND("(",A1),TRIM(MID(A1,FIND(" ",A1,4)+1,FIND("(",A1)-FIND("
",A1,4)-1)),A1),A1)

keeps everything from the first space beyond the 3rd character to the
first open parenthesis.

Jerry

 

[Steved]

Thankyou very Much Jerry

-----Original Message-----
What is your criteria for identifying what to keep?

=IF(ISNUMBER(FIND(" ",A1,4))*ISNUMBER(FIND("(",A1)),IF (FIND("
",A1,4)<FIND("(",A1),TRIM(MID(A1,FIND(" ",A1,4)+1,FIND ("(",A1)-FIND("
",A1,4)-1)),A1),A1)

keeps everything from the first space beyond the 3rd character to the
first open parenthesis.

Jerry


.

 

[Myrna Larson]

Maybe Jerry Lewis' crystal ball is working a lot better than mine <vbg>.

Did you omit part of your message? Delete what? Leave what? There's nothing in
common between your 1st and 2nd examples, so the 2nd isn't the result of the
formula applied to the 1st.

 

[Jerry W. Lewis]

You are welcome.

Jerry

 

[Steved]

Hello Myrna from Steved

I just wanted the Alpha nothing else,
so the best I could come up with is to
put it as did.