Hi Experts,

I have sheet named as "member". Column B, C and D has first, middle and last name with column A with member ID. I like to have new sheet in new workbook with column A member ID and column B with concatenating Column B, C and D of sheet "member".

Could any one help in this regards?

Regards,
Pradeep