Concatenate column B, C and D and paste result in new workbook

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

Hi Millz,

It's working like charm, but I need to save them in new workbook with one sheet with this concatenate data.

What needs to be done for this?

Pradeep

Thanks for help millz, it working as per need.