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.

 

[Joe4]

Welcome to the Board!

For an entry in cell A1, the formula to remove this might look like:

=LEFT(A1,7) & MID(A1,9,LEN(A1))

 

[Special-K99]

Try

=SUBSTITUTE(A1,"-h-","h-")

 

[Comfy]

Will this always be the second hyphen??

Excel 2010
	A	B
1	amcc-ap-h-d	amcc-aph-d
2	amcc-ar-h	amcc-arh
3	amcc-as-h-d-a	amcc-ash-d-a
Sheet1

Cell Formulas
Range	Formula
B1	=SUBSTITUTE(A1,"-","",2)

 

[SteveO59L]

=left(a1,7)&mid(a1,9,len(a1)-8)

 

[Rick Rothstein]

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

Give this formula a try...

=REPLACE(A1,8,1,"")

 

[Stiuart_W]

All the above suggestions will work well, excepting No3.

But I like Rick's the best!

 

[Special-K99]

I amended it, should be okay now.

 

[Comfy]

All the above suggestions will work well, excepting No3.

But I like Rick's the best!

I beg to differ.

Given the info provided by the OP it will work just fine.

Edit. Nevermind, I see you you're referring to post 3 not reply 3.

 

[Stiuart_W]

I would have chosen yours as the most elegant solution if only SUBSTITUTE didn't have 3 more letters than REPLACE!