remove spaces in linked worksheet object

[Guest]

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,

 

[Guest]

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

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

 

[Guest]

here is what is happening in word when I paste the excel link
.. . . revenue earned was *$4,000*, respectively . . .
the * represent spaces that are part of the excel link itself, can they be
removed so that my document reads
.. . . revenue earned was $4,000, respectively . . .

Thanks again,
dg

 

[Guest]

=--TRIM(A1)

here is what is happening in word when I paste the excel link
. . . revenue earned was *$4,000*, respectively . . .
the * represent spaces that are part of the excel link itself, can they be
removed so that my document reads
. . . revenue earned was $4,000, respectively . . .

Thanks again,
dg

 

[Guest]

I have tried TRIM, but it still shows up with a space before and after, since
it's part of a document, i need to be able to have punctuation i.e. a comma
directly after the number, any other suggestions are very appreciated.