Insert File: Problem with formulas with text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amac - 01 Sep 2005 13:00 GMT

When I do an insertfile in Word from a excel-cell which contains a formula
with a text-result (eg a concatenation of 2 cells or 2 text-values) : ____
(underscores) are shown instead of the result of the formula
Eg in Excel: ="a"&"b" -> the result in word will be "___"

Reply to this Message

amac - 01 Sep 2005 14:16 GMT

PS: I'm working in Office 2002

"amac" schreef:

> When I do an insertfile in Word from a excel-cell which contains a formula
> with a text-result (eg a concatenation of 2 cells or 2 text-values) : ____
> (underscores) are shown instead of the result of the formula
> Eg in Excel: ="a"&"b" -> the result in word will be "___"

Reply to this Message

Doug Robbins - 01 Sep 2005 19:19 GMT

You may need to do a Copy>Paste Special in Excel to paste the Values into
Excel then copy and paste them into Word.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Reply to this Message