Welcome to WebmasterWorld Guest from 54.166.189.88

Forum Moderators: phranque

Message Too Old, No Replies

excel expert for affiliate.

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

Junior Member

10+ Year Member

joined:Jan 7, 2004
posts:90
votes: 0


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)

Preferred Member

10+ Year Member

joined:Oct 11, 2003
posts:427
votes: 0


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)

Full Member

10+ Year Member

joined:Dec 2, 2003
posts:237
votes: 0


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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Jan 16, 2003
posts:746
votes: 0


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