Quote Originally Posted by DonkeyOte View Post
Going back to your first post - in principle it's basically a case of running two SUBSTITUTEs against the main string - replacing

PRODUCTWIDTH with say: TRIM(MID(D2,SEARCH("cm ",D2)-3,5))

PRODUCTLENGTH with say: TRIM(RIGHT(D2,3))

It's not clear if you will be storing the "revised" description in another column, eg:

=SUBSTITUTE(SUBSTITUTE(H2,"PRODUCTWIDTH",TRIM(MID(D2,SEARCH("cm ",D2)-3,5))),"PRODUCTLENGTH",TRIM(RIGHT(D2,3)))
encase terms in ( ) if required.. not clear

I hope that helps.
Sorry I forgot to add - I tried the =SUBSTITUTE(SUBSTITUTE(H2,"PRODUCTWIDTH",TRIM(MID(D2,SEARCH("cm ",D2)-3,5))),"PRODUCTLENGTH",TRIM(RIGHT(D2,3))) but put brackets around the PRODUCTWIDTH and PRODUCTLENGTH and then pasted it over data in column H but it just overwrit it, not sure if that was the correct method