The text data is located in a single column. I don't mind entering a formula
in each of the 160 nonadjacent cells, I just need to be able to change the
starting numerical portion of the first cell and have that change all the
following numerical portions of each cell entry.

"RagDyeR" wrote:

Where is the text data located?

Is it in a single column ... single row ... multiple locations?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Juikijui" wrote in message
oups.com...
It would look something like this:

a1=Text 1 d1=Text 2
a2=Text 3 d2=Text 4

a12=Text 5 d12=Text 6
a13=Text 7 d14=Text 8

etc... to Text 160