Do you know please the VBA function to transcode the special characters like this data into "DÉLÉGATION" ?
Asked
Active
Viewed 48 times
0
-
How did you recieve this data? Looks like it's not imported correctly. – JvdV May 06 '21 at 12:59
-
@JvdV it's the data from my excel file – VBA_Anne_Marie May 06 '21 at 13:02
-
3Usually the answer is that the imported data has not been saved as the correct UTF-8 csv data. – JvdV May 06 '21 at 13:11
-
@JvdV thank you, it's impossible to correct this data ? – VBA_Anne_Marie May 06 '21 at 13:52
-
1There's very little information in your question which could allow us to help you. Where is the data coming from? Where is that screenshot from? – Tim Williams May 06 '21 at 16:34
-
If **EVERY** � equates to a `É`, you can use `Replace`. Otherwise, you will have to go back to the Source, and either generate it properly (if it wasn't), or Import it properly (more likely to be the case). – Ron Rosenfeld May 06 '21 at 19:23
-
@RonRosenfeld, thank you, but I don't know how to write � in code VBA. – VBA_Anne_Marie May 07 '21 at 07:53
-
It is Unicode FFFD. Read about Unicode or wide characters. – Ron Rosenfeld May 07 '21 at 10:20