remove spaces in linked worksheet object
 

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,

remove spaces in linked worksheet object
 

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,

remove spaces in linked worksheet object
 

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,

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,

remove spaces in linked worksheet object
 

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.

"Teethless mama" wrote:

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