I have made some head and thanks to everyone's help so far.
I am using the same string of text:'
MECH~CDA-CUP-PF~1 - CUP0915.2XL - Copper Reducer (P)
How do I get the CDA-CUP-PF extracted using something like this?
AddFormula TopLeft.Offset(1, 3).Resize(RowCount, 1), "=LEFT(AA" & Row &...