Replacing characters dynamically?

[koshersalt]

I have a list of number I need to trim a "/" character from. I've tried replace and looked into trim functions, but don't seem to work for me.

The list looks like this:

M-FI/SS/1H
TP-CS/1
TP-T/S/2
P-HF573
S-AUTTSO1H
MTP-AUS58TH
L-AUS58TO
P-HF499
MTP-AUR8V10

But I want to look like this:


M-FISS1H
TP-CS1
TP-TS2
P-HF573
S-AUTTSO1H
MTP-AUS58TH
L-AUS58TO
P-HF499
MTP-AUR8V10

Some have the character and some don't. Would there be a way to create a formula that seeks that character and if present, deletes it?

[FDibbins]

with your data in A!, try =SUBSTITUTE(A1,"/","")

[koshersalt]

That looks like it would work, but i'm getting a circular reference warning. Am I doing something wrong? The data is in A1 and and copy pasted your formula.

Edit: Nevermind! Created a new column and pasted formula. Worked like a charm! Thanks FDibbins!

---------- Post added at 04:06 PM ---------- Previous post was at 04:02 PM ----------

Silly question, but i can't post a thanks. Any clues? I clicked the "post thanks" under your name but only tells when info.

[FDibbins]

click the star at the bottom left of the post, and thx

[koshersalt]

No, thank you!