help removing character from text string

[davillanous1]

Hello! I am needing assistance with the following issue. I have a string of text where the 8th character is always a "-" but the amount of characters that follow are different. ex:

amcc-ap-h-d
amcc-ar-h
amcc-as-h-d-a

i need to remove the 8th character from each to return the following

amcc-aph-d
amcc-arh
amcc-ash-d-a

having the string in this format will allow me to use to info for vlookups.

Please help.

 

[Stiuart_W]

I amended it, should be okay now.

I'm afraid not. The OP stated that the 8th character is always "-". Even though the 3 examples ALL have "-h" embedded you can't ASSUME the 9th character is always "h". And anyway, your code fails for option two as "-h-" is not present in the original string