Pull specific words or numbers from a cell and copy to a new one.

[wackykat80]

PULL SPECIFIC WORDS OR NUMBERS FROM A CELL AND COPY TO A NEW ONE.
EX: PULL MET.76MM(8/32)BRUSH.NICK (IN CELL G3)
ALL I WANT IS: PULL 76MM BRUSH.NICK (COPY TO C3)


I would have to do the same for cell G4:
EX: PULL MET.224MM(M4)CHROME&BLACK
All I want is: PULL 224MM Chrome&Black

Please help...I have tried so many formulas and I can't seem to find the right one!

 

[Jonmo1]

Welcome to the board...

Would it be accurate to say...

"I want to remove anything between and including ()"??

And will there be only 1 each of the parens ?


Just a different approach, it will probably be easier..

 

[Scott Huish]

=REPLACE(REPLACE(G3,FIND("(",G3),FIND(")",G3)-FIND("(",G3)+1,""),6,4,"")

Excel Workbook
	C	D	E	F	G
3	PULL 76MMBRUSH.NICK				PULL MET.76MM(8/32)BRUSH.NICK
4	PULL 224MMCHROME&BLACK				PULL MET.224MM(M4)CHROME&BLACK
Sheet1

 

[wackykat80]

WOW....yeah I would've never have figured that out. Thanks you are AWESOME!