JugglerJAF
Active Member
- Joined
- Feb 17, 2002
- Messages
- 297
- Office Version
- 365
- Platform
- Windows
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.
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) |