Remove symbol/icon from user name column

[JugglerJAF]

I have some data which can occasionally contain some unusual looking characters which appear to be icons or symbols (see below).

I have tried to identify these using the CODE function, but they both return a value of 63 (which is equivalent to ?), but the value in A4 which does not need to be amended also returns CODE 63.

Is there any way I can identify these "icon/symbol" characters so that I can remove them with a macro? I have tried using the CLEAN function but that doesn't remove these characters.

Book2
	A	B	C	D
1	NAME	LEFT(1)	CODE	CODE to CHAR
2	🏭 Adam Zapple	🏭	63	?
3	🌎 Pepper Mintz	🌎	63	?
4	Łydia Dustbliń	Ł	63	?
5	Angus Macoatup	A	65	A
6	Barb Dwyer	B	66	B
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=LEFT(A2,1)
C2:C6	C2	=CODE(B2)
D2:D6	D2	=CHAR(C2)

 

[Sufiyan97]

See if this helps

Book2
	A	B	C	D	E	F	G
1	NAME	LEFT(1)	CODE	CODE to CHAR	Final Text
2	🏭 Adam Zapple	🏭	63	?	Adam Zapple
3	🌎 Pepper Mintz	🌎	63	?	Pepper Mintz
4	Łydia Dustbliń	Ł	63	?	ydia Dustbliń
5	Angus Macoatup		#VALUE!	#VALUE!	Angus Macoatup
6	Barb Dwyer		#VALUE!	#VALUE!	Barb Dwyer
7
8
9
Sheet2

Cell Formulas
Range	Formula
B2:B6	B2	=IF(ISNUMBER(AGGREGATE(15,6,SEARCH(CHAR(SEQUENCE(27,,65)),LEFT(A2,1)),1)),"",LEFT(A2,1))
C2:C6	C2	=CODE(B2)
D2:D6	D2	=CHAR(C2)
E2:E6	E2	=TRIM(SUBSTITUTE(A2,B2,""))

 

[Fluff]

You could use

=UNICODE(B2)

to find out what the characters are.

 

[JugglerJAF]

You could use

=UNICODE(B2)

to find out what the characters are.

That's sorted it. Many thanks.

 

[Fluff]

Glad we could help & thanks for the feedback.