C
CaptainHook
Please help me with this task:
I would like to define each "cell value" a string of chars with a code
name
(for example, cell A1: coded name="101", val="The"; cell A2: code
name=102, val="quick"; cell A3: coded name=103, val="brown"; cell A4
coded name=104, val="fox", etc.)
Then some how on Cell B9 for example, I want to define this
formular: "101" + "102" + "103" + "104"
so that I can have the visible value in Cell B9 as:
"The quick brown fox"
And Cell B10, for example, another formular: "101" + "102" + "104"
for "The quick fox"
etc.
Is it possible to do these kind of things with Excel ? If yes, pleas
help me or point me to where I can find out more info.
Thank a bundle in advance
I would like to define each "cell value" a string of chars with a code
name
(for example, cell A1: coded name="101", val="The"; cell A2: code
name=102, val="quick"; cell A3: coded name=103, val="brown"; cell A4
coded name=104, val="fox", etc.)
Then some how on Cell B9 for example, I want to define this
formular: "101" + "102" + "103" + "104"
so that I can have the visible value in Cell B9 as:
"The quick brown fox"
And Cell B10, for example, another formular: "101" + "102" + "104"
for "The quick fox"
etc.
Is it possible to do these kind of things with Excel ? If yes, pleas
help me or point me to where I can find out more info.
Thank a bundle in advance