• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

Help with merging columns in Excel file

Hi,

How do you merge columns in an excel file?

Victor
0
vcharles
Asked:
vcharles
  • 13
  • 7
1 Solution
 
Naresh PatelTraderCommented:
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
0
 
vcharlesAuthor Commented:
Thanks, I will try it and get back to you.
0
 
Naresh PatelTraderCommented:
Pls see attached for better understanding...


Thanks
Column-Combine.xlsx
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
vcharlesAuthor Commented:
How do I include the formula?
0
 
Naresh PatelTraderCommented:
May I have your sample file .... I will do it on your behalf...

Thanks
0
 
vcharlesAuthor Commented:
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.
0
 
Naresh PatelTraderCommented:
ok then tell me which column you want to combine & do u want spaces between ?

Thanks
0
 
vcharlesAuthor Commented:
I want to combine the columns 6 to 11 with no spaces between the data.

Thanks,

V.
0
 
Naresh PatelTraderCommented:
ok give me one moment....it means from column F to K without spaces right ? & result in column L right?
0
 
Naresh PatelTraderCommented:
Use this in Cell L1 & copy past to lower rows or use drop down.
=F1&G1&H1&I1&J1&K1

Open in new window

0
 
Naresh PatelTraderCommented:
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

Open in new window

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

Open in new window

0
 
Naresh PatelTraderCommented:
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

Open in new window

0
 
Naresh PatelTraderCommented:
This is sample just see how it is works.

Thanks
Column-Combine.xlsx
0
 
vcharlesAuthor Commented:
I have headers in all the columns, heading to the office will get back to you within the hour.

Thanks.

V.
0
 
Naresh PatelTraderCommented:
ok & I am heading towards Home  :)


Thanks
0
 
Naresh PatelTraderCommented:
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
0
 
vcharlesAuthor Commented:
Hi,

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

Thank You.

Victor
0
 
Naresh PatelTraderCommented:
Tell me what you dint understand I will post screen shots of every steps.

Thanks
0
 
vcharlesAuthor Commented:
Hi,

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

Thank You.

Victor
0
 
Naresh PatelTraderCommented:
Glade to help you ...


Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 13
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now