extract word from a cell and copy to a new cell...

[wackykat80]

Example: PULL MET.76MM (8/32) BRUSHED NICKEL (column G)
All I need is: 76MM to copy to column C

Example: PULL MET.224MM (M4) CHROME&BLACK (COLUMN G)
All I need is: 224MM

Please help.

 

[Andrew Poulsom]

For your sample data try this formula:

=LEFT(MID(G1,FIND(".",G1)+1,255),FIND(" ",MID(G1,FIND(".",G1)+1,255))-1)

 

[wackykat80]

Thank you so much....I love you guys! I try using the help thing but I was getting nowhere!

Gave me thanks again!