Welcome to WebmasterWorld Guest from 23.22.46.195

Forum Moderators: phranque

excel expert for affiliate.

   
8:18 pm on Mar 30, 2005 (gmt 0)

10+ Year Member



help.
how can you merge two colums in to one colum.Excel 2004 Do we have any excel expert? Thanks
8:56 pm on Mar 30, 2005 (gmt 0)

10+ Year Member



Merge Cell Wizard is an add-on that can do it but it's not free. I think the easiest way is to copy the cells into notepad. Wrap each line in notepad with quotes then copy back to excel. If you have ultraedit, then just go to search/replace all, turn regex on and replace ^p with "^p". Cells copied into a text editor will be delimited by a tab - so another way to merge cells is to get rid of the tabs then copy back into excel.
9:17 pm on Mar 30, 2005 (gmt 0)

10+ Year Member



Just looked it up in the Excel help using the word "merge".

If you have something in A1 and B1 and want to combine to C1, put this in C1 (this takes the text from A1 and B1 and adds a space between the two.

=A1&" "&B1

Then just copy the formula in the rest of the C column by pulling the corner of C1 down.

If you want the merge to be a permanent value, just copy the results of the C column and Paste Special into a blank column using "values". That's it.

9:19 pm on Mar 30, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Insert a blank column in the spreadsheet and in the first row add a formula to concatenate the two columns you want. For example in Cell C1 add:
=A1&B1
Then drag the formula down the column to apply it to all the rows you want.

If you need a space try:
=A1&" "&B1

 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month