To merge multiple columns to single

Computing.Net > Forums > Office Software > To merge multiple columns to single

To merge multiple columns to single

Original Message

Name: vasuki
Date: May 28, 2007 at 23:00:00 Pacific
Subject: To merge multiple columns to single
OS: Windows XP
CPU/Ram: 512MB
Model/Manufacturer: Intel

Comment:

Hi, i have another doubt how to merge the multiple columns into a single column. For Eg.1st column has xx 2nd column has yy, i want the 1st column to have both the values xxyy. Can you please help?

Report Offensive Message For Removal

Response Number 1

Name: Bryco
Date: May 29, 2007 at 03:32:27 Pacific
Subject: To merge multiple columns to single

Reply: (edit)

In C1 use:
=CONCATENATE(A1,B1)
or simply
=A1&B1
Then drag your formula down C column or place the cursor over the bottom right hand corner of C1 and double click to drag it down automatically.
Bryan

Report Offensive Follow Up For Removal

Response Number 2

Name: Jennifer SUMN
Date: May 29, 2007 at 06:11:30 Pacific
Subject: To merge multiple columns to single

Reply: (edit)

Assuming of course that you're using Excel. :)
Life is more painless for those who are brainless.

Report Offensive Follow Up For Removal

Response Number 3

Name: vasuki
Date: May 29, 2007 at 22:48:16 Pacific
Subject: To merge multiple columns to single

Reply: (edit)

Hi Thanks its working but if i need a space between the two means wat should i do?

Report Offensive Follow Up For Removal

Response Number 4

Name: Bryco
Date: May 30, 2007 at 11:13:06 Pacific
Subject: To merge multiple columns to single

Reply: (edit)

=A1&" "&B1
Should do it.
Regards,
Bryan

Report Offensive Follow Up For Removal


Combining more columns to single Merge multiple wksht in Excel07 Excel columns to email address paste excel graphs to powerpoint Export Data and Import to Excel	VCD to DVD Text file to Access help Merge rows in Excel & del duplicate Using Access form to create query Forward multiple emails at once

Keeping hyperlinks from D...

full contorl on specific ...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: To merge multiple columns to single

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

IEEE 1394 controller driver

desktop problem

Problem With windows Update

Snap Network

Need help

All Posts Awaiting Replies