[Solved] Extracting the characters between two – in the current string in an excel macro [closed]

by


In your case, if the suggested method Text-To-Columns is not an option somehow, you could use:

=TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",LEN(A1))),2*LEN(A1)+1,LEN(A1)))

enter image description here

This part 2*.. stands for (N-1)*.., in this case the third ‘word’

More information here

solved Extracting the characters between two – in the current string in an excel macro [closed]