Concatenation

**ram117** · 07-16-2009, 07:26 AM

Hi,

Thanks for the immediate reply

But Its not working When A3 is vacant then it should pickup the value from B3 and concatenate B3&A4, B3&A5, B3&A6 till it find a empty cell in the Col A.

If A7 is empty then it should pick the value of B7 and concatenate B7&A8, B7&A9 in the column C

Hope Now I have given a clear Idea about what I need.

Regards

Ramana

**DonkeyOte** · 07-16-2009, 02:08 PM

Hope Now I have given a clear Idea about what I need.

Not at all I'm afraid.

The formula provided generates the exact same results you specify in your file, if they're not correct I suggest a load a sample file which contains the correct desired output.