Remove 1st char after a special char

[DQ2013]

Hi I have the follow data . I need to remove the 1 character after the "." The result I require taking the first row must return as CWRX192.S or CWRX192.XL for the 4th row. Please help. thanks you

CWRX192.CS

CWRX192.DM

CWRX192.EL

CWRX192.FXL

CWRX192.G2XL

CWRX192.G3XL

CWRX192.G4XL

 

[Alex Blakenburg]

See if this works for you:

=IFERROR(REPLACE(A2,FIND(".",A2)+1,1,""),A2)

Book1
	A	B
1	Original Data	After Replace
2	CWRX192.CS	CWRX192.S
3	CWRX192.DM	CWRX192.M
4	CWRX192.EL	CWRX192.L
5	CWRX192.FXL	CWRX192.XL
6	CWRX192.G2XL	CWRX192.2XL
7	CWRX192.G3XL	CWRX192.3XL
8	CWRX192.G4XL	CWRX192.4XL
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=IFERROR(REPLACE(A2,FIND(".",A2)+1,1,""),A2)

 

[DQ2013]

See if this works for you:

=IFERROR(REPLACE(A2,FIND(".",A2)+1,1,""),A2)

Book1
	A	B
1	Original Data	After Replace
2	CWRX192.CS	CWRX192.S
3	CWRX192.DM	CWRX192.M
4	CWRX192.EL	CWRX192.L
5	CWRX192.FXL	CWRX192.XL
6	CWRX192.G2XL	CWRX192.2XL
7	CWRX192.G3XL	CWRX192.3XL
8	CWRX192.G4XL	CWRX192.4XL
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=IFERROR(REPLACE(A2,FIND(".",A2)+1,1,""),A2)

It works Thank you very much for your quick response.

 

[Alex Blakenburg]

You're welcome. Glad I could help.