remove spaces in linked worksheet object

D

dg

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,
 
M

Michael

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

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

dg

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
 
T

Teethless mama

=--TRIM(A1)


dg said:
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
Click to expand...
 
D

dg

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.
 
Top