Amateur Radio Callsign - remove characters

[Carl_London]

UK Amateur Radio callisgn begin with are in the format 1 or 2 letters followed by a number, there is a exception where the callsign begins with the number 2 and a letter.
Valid UK callsigs begin with a G, an M or a 2

For G or M callsign:
I want to convert callsign where if there are two letter before the number the second letter is deleted, so:

G1ABC remains G1ABC
GM1ABC would become G1ABC
M6XYZ remains M6XYZ
MS6XYZ would become M6XYZ

For 2 callsign:
The letter following the 2 is always converted to an X

2E0AAA would become 2X0AAA
2W0AAA would become 2X0AAA

Thanks for any help!

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	G1ABC	G1ABC
3	GM1ABC	G1ABC
4	M6XYZ	M6XYZ
5	MS6XYZ	M6XYZ
6	2E0AAA	2X0AAA
7	2W0AAA	2X0AAA
Data

Cell Formulas
Range	Formula
B2:B7	B2	=IF(LEFT(A2)="2",REPLACE(A2,2,1,"X"),IF(ISNUMBER(--MID(A2,2,1)),A2,REPLACE(A2,2,1,"")))

 

[Carl_London]

IF(LEFT(A2)="2",REPLACE(A2,2,1,"X"),IF(ISNUMBER(--MID(A2,2,1)),A2,REPLACE(A2,2,1,"")))

Thanks you so much, but I only need the second half of the formula to work for callsigns beginning with a G or an M. If a callsign begins with a W, if WB1ABC that should remain WB1ABC.

I just also forgot one thing. Callsigns beginning GB should remain GB so GB1ABC would remain GB1ABC. I've been trying to add the exception to formula but can't get it to work.
Your thoughts on this final piece of the puzzle would be very welcome.

Sorry to be a pain!

Thanks again, Carl

 

[Fluff]

Ok, how about

=IF(LEFT(A2)="2",REPLACE(A2,2,1,"X"),IF(LEFT(A2,2)="GB",A2,IF(AND(OR(LEFT(A2)={"M","G"}),ISERR(--MID(A2,2,1))),REPLACE(A2,2,1,""),A2)))

 

[Carl_London]

Ok, how about

=IF(LEFT(A2)="2",REPLACE(A2,2,1,"X"),IF(LEFT(A2,2)="GB",A2,IF(AND(OR(LEFT(A2)={"M","G"}),ISERR(--MID(A2,2,1))),REPLACE(A2,2,1,""),A2)))

Fluff you are my hero!

Very many thanks, by the way love the England Rugby bagde.

All the best, Carl

 

[Fluff]

You're welcome & thanks for the feedback.