Using Excel for text variables

[dreamking11]

Hey all,
I can't figure a better way to do this so I am turning to Excel.

What I would like to do is be able to enter for example 'Joe' into a cell, hit tab and have another cell update to 'Hi Joe, how are you Joe'.
It's more involved than that but if I can get started with that basic thing I think I can figure the rest out.

I know Excel isn't ideal for this but it should be possible isn't it? I've also looked into javascript, Flash, Word and standalone programs but can't come up with a good solution.

TY!

[oldchippy]

Hi Dreamking11,

Welcome to the forum, how about this, in B1 and Joe in A1

Please Login or Register  to view this content.

then when you fill in A1 and hit enter you get

Hi Joe, how are you Joe

[dreamking11]

Super, thanx oldchippy!
One more thing... how can I add a carriage return to the end of the line so that I can put 'Mary' in A2 and get:

Hi Joe, how are you Joe
Hi Mary, how are you Mary

I've turned word wrap in the cell on and tried alt+enter

=IF(A1="","","Hi "&A1&", how are you "&A1)
=IF(A2="","","Hi "&A2&", how are you "&A2)

But the cell says 'false'...

[oldchippy]

Try this it may be what you want?

[dreamking11]

Thanx a lot for the effort. That's almost it except that each needs to be on it's own line by coding. Is that possible?
What I am trying to accomplish is to make it generate a list that needs to be pasted elsewhere, with each entry on it's own line.

[oldchippy]

How about the other way Joe in A1 and Mary in A2, with the formula in B1, then another formula in B2

=IF(A1="","","Hi "&A1&", how are you "&A1)

=IF(A2="","","Hi "&A2&", how are you "&A2)

So that they are under each other?

[dreamking11]

Okay yes, I didn't realize that I could select multiple cells and copy/paste them to make a list that way.
Thanks for your efforts this is going to save me a lot of work!

[oldchippy]

Glad to help - thanks for the feedback