Quote Originally Posted by visionwindowfilms
Im currently doing a project similar to one I got help with on here in the past, if you see the attachment you'll notice in the title on column D it will havea variety of widths and lengths such as 50cm x 1m (50cm being the width and 1m being the length). In column H I will be writing a Title and the only variables will be the width and length so I was goign to write an identical descrition but anywhere I refer to the width Ill write (PRODUCTWIDTH) and anywhere I refer to length Ill write (PRODUCTLENGTH). Is there any way of creating a formula that will then change that to whatever it says in the title.
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.