(!Syntax Error, *)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Suse - 23 Sep 2004 18:19 GMT

Hi,
I'm trying to merge data from an excel file version 2002, to microsoft word
2002.

A bit of background - I am generating stats of individuals for a supervisor
that merges to a table. He needs to be able to compare individuals stats and
the team info on the same table. I had to force word to use percentage
information, (thank you g.mayor.com!!)

The table merges fine if he is merging stats for 11 people (the exact # of
rows in the table) -- when trying to merge less than 11 people, each cell in
the remaining rows (with no data from excel) are filled in with:
(!Syntax Error, *)

My merge percentage formula is:
{={MERGEFIELD "Pct_Ework_Issues"}*100\#"0%"}

I need to force word to return blank info for blank cells in Excel. I've
searched & searched and can't find any info regarding an error like this.
Any and all suggestions greating appreciated as tomorrow is my last day in
this postion & I'd love to have this completed for the manager :o)))))))

THANKS!!!!

Reply to this Message

Doug Robbins - 24 Sep 2004 00:15 GMT

Use

{ IF {MERGEFIELD "Pct_Ework_Issues"}="" "" {={MERGEFIELD
"Pct_Ework_Issues"}*100\#"0%"}}

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hi,
> I'm trying to merge data from an excel file version 2002, to microsoft
[quoted text clipped - 24 lines]
>
> THANKS!!!!

Reply to this Message

Graham Mayor - 24 Sep 2004 09:58 GMT

Or coversely

{ IF {MERGEFIELD "Pct_Ework_Issues"} <> "" "{={MERGEFIELD
"Pct_Ework_Issues"}*100\#"0%"}"}

;)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Use
>
[quoted text clipped - 30 lines]
>> is my last day in this postion & I'd love to have this completed for
>> the manager :o))))))) THANKS!!!!

Reply to this Message

Suse - 24 Sep 2004 20:29 GMT

Many thanks to both of you!!!!!

:o)))))))))

> Or coversely
>
[quoted text clipped - 37 lines]
> >> is my last day in this postion & I'd love to have this completed for
> >> the manager :o))))))) THANKS!!!!

Reply to this Message

macropod - 30 Sep 2004 15:23 GMT

Or even:

{={MERGEFIELD "Pct_Ework_Issues"}*100 \# 0%;-0%;}

Cheers

> Or coversely
>
[quoted text clipped - 37 lines]
> >> is my last day in this postion & I'd love to have this completed for
> >> the manager :o))))))) THANKS!!!!

Reply to this Message