I have database files that I import into Excel 2003. In certain columns
there are unicode characters, e.g. •œ . I use the find and replace function
to replace these charactrers with numbers. I can do this fine by hand. When
I record a macro to do the same, it doesn't work. The macro replaces the •œ
characters with the plus sign "+" which breaks it. I've tried editing the
macro by placing the •œ characters in the formula, but that doesn't work
either. The editor won't allow it, replacing the •œ with a question mark "?".
Does anyone know how I can get this to work. I do this almost daily I would
hate to do it manually every time.