Extract words from a cell and copy to a new cell....

[wackykat80]

example: HINGE SBR.60X40MM (LEFT) BRASS (column G3)
all I need: HINGE 60x40mm brass (column c3)

I have been using a formula that has worked for most of my work but I think this one has more characters in the first word. Can someone please help?????

 

[Leith Ross]

Re: Ectract words from a cell and copy to a new cell....

Hello wackykat80,

Without more samples of the data and detailed explanations of the parsing rules, it is impossible to recommend a viable solution.