I am now trying to recreate my Excel VBA formula on a worksheet to pick it apart.
I have the following text in cell A1
I have the following in cell A3:
I am getting the error you need to type an apostrophe first.
I tried that and I still get an error.
When I try this formula in VBA it does start to work.
Can someone clue me in?
I have the following text in cell A1
Code:
MECH~CDA-CUP-PF~1 - CUP0915.2XL - Copper Reducer (P)
I have the following in cell A3:
Code:
=IFERROR(LEFT("A1", FIND("" ~ "")+1, FIND(("-",("A1"))+1,FIND(("-",("A1")+1)
I am getting the error you need to type an apostrophe first.
I tried that and I still get an error.
When I try this formula in VBA it does start to work.
Can someone clue me in?