Quote Originally Posted by JBeaucaire View Post
Hi Praney. Welcome to the forum.

This is doable, but will most likely involve adding some VBA to your workbook. You OK with us using macros to solve this? This isn't the programming forum, so I thought I should ask before spending any time on it.

If so, click GO ADVANCED and use the paperclip icon to post up your workbook. Make sure the sample workbook has a few sample "results" so we can clearly see your goal.

Also, is this a one-off need? Or do you need something that is operating all the time in real-time to keep these concatenated fields filled in?
Sorry didn't your whole message,
I am not familiar with macros I am a newby.
I think I'll take it to the programming section.

Well thanks a lot for your help though.

Cheers,

Praney