excel expert for affiliate.

[wnshops]

help.
how can you merge two colums in to one colum.Excel 2004 Do we have any excel expert? Thanks

[iblaine]

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.

[flobaby]

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.

[MrSpeed]

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