Remove Part Of A Text String

[Kurt]

I have the following info in cell D5: MECH^CHU-BSW-PF

Using the following VBA code what do I add to take out the MECH^ part of the text string in cell D5?

My code needs to stay in this format just FYI.

    AddFormula TopLeft.Offset(1, 2).Resize(RowCount, 1), "=IFERROR(LEFT(AA" & Row & ",FIND(""^"",AA" & Row & ")+10),"""")"

 

[6StringJazzer]

It's hard to understand what you want, since your existing code does not reference D5.

The expression to return the value of D5 with "MECH^" removed is

Replace(Range("D5"), "MECH^", "")

but I have no idea how you want to use that in your existing code.