Help with merging columns in Excel file

Formula to merge column content.
=A2&B2&C2&D2

So & is combining content of cells if you want to add space between than
=A2&" "&B2&" "&C2

Thanks

Thanks, I will try it and get back to you.

Pls see attached for better understanding...


Thanks
Column-Combine.xlsx

How do I include the formula?

May I have your sample file .... I will do it on your behalf...

Thanks

Unfortunately I can't send you the file. Can you please send me some instructions.

I typed the formula in the formula editor but don't know how to execute it to apply to all the rows.

Thanks,

V.

ok then tell me which column you want to combine & do u want spaces between ?

Thanks

I want to combine the columns 6 to 11 with no spaces between the data.

Thanks,

V.

ok give me one moment....it means from column F to K without spaces right ? & result in column L right?

Use this in Cell L1 & copy past to lower rows or use drop down.

=F1&G1&H1&I1&J1&K1

Select allOpen in new window

if there is header in Row 1 then put this formula in cell L2 & just copy past or dropdown

=F2&G2&H2&I2&J2&K2

Select allOpen in new window

=F1&G1&H1&I1&J1&K1

Select allOpen in new window

if there is header in Row 1 then past this formula in L2 & copy past or drop down in lower rows.

Thanks

=F2&G2&H2&I2&J2&K2

Select allOpen in new window

I have headers in all the columns, heading to the office will get back to you within the hour.

Thanks.

V.

ok & I am heading towards Home  :)


Thanks

If you tell me how exactly final result you wants then I will guide you properly.
1.want to combine column value as it is.
2.Combine and delete combined columns and need final only one column.

Thanks

Hi,

I need to understand your previous posts and try again, will get back to you.

Thank You.

Victor

Tell me what you dint understand I will post screen shots of every steps.

Thanks

Hi,

I'm sorry for the late reply. I figured it out.

Thank You.

Victor

Glade to help you ...


Thanks