GSTEEL320
New member
- Local time
- Yesterday, 18:55
- Joined
- Nov 11, 2018
- Messages
- 10
I've come across these for the first time recently. It would appear I import an excel sheet with several of these type of characters, which is causing issues when joining the data within that particular field.
I have seen a few vba solutions, which can be hit and miss if the characters are not always the same type.
So my question is this.... Will converting the file to a text file before import, remove these characters?
I'm considering writing vba to do this anyway, but I'm always open to a second opinion ......
I have seen a few vba solutions, which can be hit and miss if the characters are not always the same type.
So my question is this.... Will converting the file to a text file before import, remove these characters?
I'm considering writing vba to do this anyway, but I'm always open to a second opinion ......