you can do it by placing the ~ before your * when doing replace like so:

Replace ~*
with nothing don't even use the space bar.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"dg" wrote:

I am linking worksheet objects (accounting format) as unformatted unicode
text into a word document so that the document is updated with the worksheet.
But, the link has a space (*) before and after the # amount, *$X,XXX*, can I
remove the *'s?

Thank you,