text formula in Word 2004?

[the3rdParty]

Is there any way to do text formulae in a table in MS word? I want
to be able to enter a text value in one cell and have the same text
appear in other cells in the same table. If it was a numeric value
this would be v straight forward, but it seems that formulae in Word
2004 are only numeric and not text.

The only work around I can think of would be to insert an excel table
in the word doc. This would certainly work but I was looking for a
less clumsy solution


jim

MS Word 2004 11.4.2
OS X 10.4.11
iMac Intel Core 2 Duo

 

[John McGhie]

Hi Jim:

Look up "Cross reference" in the Help, and see if that will do what you
need.

However, if you are looking for string manipulation, that gets a lot more
complex.

Come back if that's the case, and we will try to help. But we will need
exact details of what you need to do.

Cheers

Is there any way to do text formulae in a table in MS word? I want
to be able to enter a text value in one cell and have the same text
appear in other cells in the same table. If it was a numeric value
this would be v straight forward, but it seems that formulae in Word
2004 are only numeric and not text.

The only work around I can think of would be to insert an excel table
in the word doc. This would certainly work but I was looking for a
less clumsy solution


jim

MS Word 2004 11.4.2
OS X 10.4.11
iMac Intel Core 2 Duo

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:[email protected]

 

[the3rdParty]

John

The result I was looking for is as follows:

I wanted to insert some text in cell A1 of a Word table and have the
same text appear automatically in cells B3 and B4. If I had been
dealing with numbers rather than text this could be easily achieved
using Insert / Field / Formula / =A1 in the cells where I wanted the
content of cell A1 to be repeated. This however ONLY reports numeric
results and if A1 contains text, Insert / Field / Formula / =A1 gives
a result of 0

Thinking about your hint of using cross referencing I remembered paste
special / paste link which works just fine! I selected the text in
A1, Copy, click in cell B3, paste special / paste link button /
formatted text and its done. Repeat the paste special for cell B4

The nice detail about this solution is that when the text cell A1
changes, the text in B3 and B4 updates itself instantly, without the
need for field update or similar. However care must be taken when
editing the contents of the source cell (A1) as if you simply add text
on to the end of the source text it falls outside of the 'field' and
is not seen as part of the source information. I thought it might be
possible to get round this by selecting the entire cell A1 (rather
than just the text therein) as the source data, but it seems that
"paste link" is then unavailable in under "paste special".


Solved!

Jim

 

[John McGhie]

Hi Jim:

That is being done with a LINK field (Similar to a cross-reference).
However, the LINK field inserts an OLE link.

To see the parameters, go to Insert>Field>All Fields and scroll down to
LINK.

The source is a bookmark. To see the bookmark, go to
Preferences>View>Bookmarks. You will see two heavy [ ] brackets
surrounding the source.

To play with the bookmark, select some text and go to Insert>Bookmark and
look for bookmarks named OLE_LINK with a serial number on the end.

Now you know how it all works, you can do some seriously evil things with
this mechanism

Cheers

John

The result I was looking for is as follows:

I wanted to insert some text in cell A1 of a Word table and have the
same text appear automatically in cells B3 and B4. If I had been
dealing with numbers rather than text this could be easily achieved
using Insert / Field / Formula / =A1 in the cells where I wanted the
content of cell A1 to be repeated. This however ONLY reports numeric
results and if A1 contains text, Insert / Field / Formula / =A1 gives
a result of 0

Thinking about your hint of using cross referencing I remembered paste
special / paste link which works just fine! I selected the text in
A1, Copy, click in cell B3, paste special / paste link button /
formatted text and its done. Repeat the paste special for cell B4

The nice detail about this solution is that when the text cell A1
changes, the text in B3 and B4 updates itself instantly, without the
need for field update or similar. However care must be taken when
editing the contents of the source cell (A1) as if you simply add text
on to the end of the source text it falls outside of the 'field' and
is not seen as part of the source information. I thought it might be
possible to get round this by selecting the entire cell A1 (rather
than just the text therein) as the source data, but it seems that
"paste link" is then unavailable in under "paste special".


Solved!

Jim

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:[email protected]