string concatenation

  • Thread starter Thread starter CaptainHook
  • Start date Start date
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
 
Back
Top