Excelwimb, merge two rows

[Classic Jorge]

Sorry, I'm aware of how boring this is but I have an excel sheet and all I need to do is merge data from column a and column b together, no spaces, in a third column.

Any help much appreciated

[Steve Williams - gay for Mark Knopfler]

[Bergkamp's Brain]

[gooner4life]

[ITSUPFORGRABSNOW]

[Classic Jorge]

I'm virtually voiding the warranty running the thing

[ITSUPFORGRABSNOW]

[Classic Jorge]

[Steve Williams - gay for Mark Knopfler]

I know how to do it in Foxpro which again is Microsoft.

Never really use excel.

[Classic Jorge]

[Classic Jorge]

[Bergkamp's Brain]

You can do that for the whole column in one go.

Filing that :wipecock:

[ITSUPFORGRABSNOW]

[Classic Jorge]

=CONCATENATE(A2,B2) isnt playing

[Classic Jorge]

The ******* only went and worked.

Nice one, thanks very much

[dismalswamp]

[Mack]

In cell C1, enter the formula “=A1&B” ( no spaces) or “=A1&" "&B1&" "(spaces)

Then press Enter key and select the cell C1, drag the fill handle over the range of cells that you want to apply this formula.



http://www.extendoffice.com/documents/excel/510-merge-column s-keep-data.html (http://www.extendoffice.com/documents/excel/510-merge-columns-keep-data.html)

[Steve Williams - gay for Mark Knopfler]

The concatentate thing works fine here.

Send me your spreadsheet and we'll call it quits.

:thumbup:

[Classic Jorge]

[Bergkamp's Brain]

Contact the desk is what they say, contract the desk.

[Norn Iron]