I have imported some data from a table on our local intranet but there is
character in some of the cells which is an extended version of the normal
dash like this one ' ˆ’ '
Wheras this is normal keyboard dash ' - '

I have tried doing a find/replace to make it a zero but it is not found when
this character is placed in VBA it looks just like a normal dash.

Can anyone assist with a solution, please?

Mark