Changing variables

**Maxjacobs** · 08-20-2009, 02:18 AM

Hi All,

I'm kind'a new to excel, and I need something basic (I hope)

I need to create a text with variables and generate new text according to the new variables

for example:

My text:

"I'm Var1 and I like to Var2"

Var1= Sweet, Big, Nice
Var2= Dance, Smile, jump

Now I want to generate 3 new sentences from that:

- I'm Sweet and i like to Dance
- I'm Big and I like to Smile
- I'm Nice and I like to Jump

Is that possible? if so, how?

Many thanks,
Max

**DonkeyOte** · 08-20-2009, 02:23 AM

Not really clear ... let's say you want to create the three strings in A1:A3

A1: ="I'm "&INDEX({"Sweet","Big","Nice"},ROWS(A$1:A1))&" and I like to "&INDEX({"Dance","Smile","Jump"},ROWS(A$1:A1))

copied to A2:A3

**Maxjacobs** · 08-20-2009, 02:40 AM

Thanks : )

But I was hoping that in A1 I'll have the basic sentence, and then on A2 and A3 have Var1 and Var2

And the output could be in a new Spreadsheet tab within the same file

Is that possible?