string concatenation

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
 
F

Frank Kabel

Hi
this would require VBA to concatenate the strings. Do you want to go
this way?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can this be done? 4
Macro for comapre and copy 13
Please Help 2
Please help really need this to work 6
Copy in order 3
Concatenate with differents conditions 3
EXCEL LOOKUP 4
Importing multiple Text files into Excel 2

Top