get ID

[chaboyski]

Hi Team,

just wanted to check how i can extract the ID on the sample below. i tried using =MID(E3,FIND("(",E3)+1,6) but the number of the characters varies.

i just need to extract the one inside the parethesis

test2.xlsx
	E	F
3	Chavez, Vincent (chaboy)	chaboy
4	Sample, One (one)	one)
5	Sample, Three (three)	three)
Sheet3

Cell Formulas
Range	Formula
F3:F5	F3	=MID(E3,FIND("(",E3)+1,6)

thank you so much

 

[Fluff]

If it's always at the end of the string try

=SUBSTITUTE(MID(E3,FIND("(",E3)+1,100),")","")

 

[chaboyski]

If it's always at the end of the string try

=SUBSTITUTE(MID(E3,FIND("(",E3)+1,100),")","")

Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.