remove spaces in linked worksheet object
=--TRIM(A1)
"dg" wrote:
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
"Michael" wrote:
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,
|