[ronduke]

How do you identify unconnected cells in a Word Table to create an accurate
formula? I have a Table where not all cells are numerical, but broken up by
cells with text in them.

thanks,
ronduke

[Greg Maxey]

In formulas cells are referenced by an alpa-numberic index. A1 is the first
column first row. Z26 is the 26th column and 26th row

So if you wanted to add A1 to Z26 you would used {=(A1+Z26)}
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~



ronduke wrote:
How do you identify unconnected cells in a Word Table to create an
accurate formula? I have a Table where not all cells are numerical,
but broken up by cells with text in them.

thanks,
ronduke

[ronduke]

Greg,
Thanks for responding. However, that doesn't answer my question. There are
no precise columns as the rows have differing numbers of cells, some text and
some currency and other numbers. With no clear cut columns, how do I
identify specific cells?

"Greg Maxey" wrote:

In formulas cells are referenced by an alpa-numberic index. A1 is the first
column first row. Z26 is the 26th column and 26th row

So if you wanted to add A1 to Z26 you would used {=(A1+Z26)}
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~



ronduke wrote:
How do you identify unconnected cells in a Word Table to create an
accurate formula? I have a Table where not all cells are numerical,
but broken up by cells with text in them.

thanks,
ronduke

[Suzanne S. Barnhill]

See http://gregmaxey.mvps.org/Table_Cell_Data.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"ronduke" wrote in message
...
Greg,
Thanks for responding. However, that doesn't answer my question. There
are
no precise columns as the rows have differing numbers of cells, some text
and
some currency and other numbers. With no clear cut columns, how do I
identify specific cells?

"Greg Maxey" wrote:

In formulas cells are referenced by an alpa-numberic index. A1 is the
first
column first row. Z26 is the 26th column and 26th row

So if you wanted to add A1 to Z26 you would used {=(A1+Z26)}
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~



ronduke wrote:
How do you identify unconnected cells in a Word Table to create an
accurate formula? I have a Table where not all cells are numerical,
but broken up by cells with text in them.

thanks,
ronduke