Sign after 2 first letters

[makinmomb]

GC-0092 #3900
GC-0114 #7500
GC0120#6950


I have this on a1 downwards

Formula on b1 to drag down for result

GC-0092 #3900
GC-0114 #7500
GC-0120#6950

To put the if it not exists , if it exists to leave it as is

[shg]

Row\Col	A	B	C
2	GC-0092 #3900	GC-0092 #3900	B2: =REPLACE(A2, 3, MID(A2, 3, 1) = "-", "-")
3	GC-0114 #7500	GC-0114 #7500
4	GC0120#6950	GC-0120#6950

[makinmomb]

Not working

It gives

GC- - 0092 #3900
GC-0114 #7500
GC-0120#6950

[makinmomb]

I want it to tackle those where there are no signs , and leave the cells intact where the sign exists

[Jonmo1]

It worked fine for me..

Maybe you had the cell reference wrong, change the A2's to A1's ??

[makinmomb]

Find attached , getting double sign , where not required

[shg]

There's a space before the hyphen in A1. A space is not a hyphen, so the formula inserts one.

[Jonmo1]

The value you have in A1 is different from what you originally posted..

GC-0092 #3900
GC-0114 #7500
GC0120#6950

But in the book you just posted, A1 is actually
GC - 0092 #3900

There are spaces around the -

Is that book you posted a realistic example of all the possible formats of the value in A ?

[makinmomb]

Oh i get it now

[makinmomb]

Thank you very much everybody

[shg]

You're welcome.