Help request to concatenate

Hi friends,

I want to concatenate columns in column ‘G’ and ‘O’. In column ‘O’ I want to drop middle name but I’m not getting the correct output as require.

Any help will be highly appreciated.

Thanking you,

Why not just use a regular formula?
=TRIM(C9&" "&E9&" "&F9&" "&D9)
copied down

Hi Ford,
Thank you for your suggestion. Actually I have a formula

Please Login or Register  to view this content.

and it's working fine but now I want to use vba code to achieve this target and remove formula.

Any suggestion to avoide the problem please!

You just need to empty your string before building it for the "O" column.

Please Login or Register  to view this content.

Hello Skywriter,
Perfect! It's working fine.

Thank you and have a nice time.

My pleasure, thanks for the rep. points.