HEELPBOOK - Excel - VBA or Formula - Combine 2 columns #################

######## SCENARIO

Column A has last name, Column B has first name. I want to joing data of 2 columns to show Firstname Lastname in ColumnA and then delete Column B.


######## SOLUTION (Using Formula)

You can do without code. Use the formula...


=A1 & " " & B1


in column C and copy down. Then copy the formula cells and do an edit, paste special values back over the formulas. Then delete columns A and B.


###### SOLUTION (Using VBA)

Right click your sheet tab, View code and paste this in and run it.


Sub sonic()
lastrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row
Set MyRange = Range("A1:A" & lastrow)
For Each c In MyRange
c.Value = c.Offset(, 1).Value & " " & c.Value
Next
Columns(2).ClearContents
End Sub



############ ARTICLE INFO #############

Article Month: May
Article Date: 03/05/2012
Permalink: http://heelpbook.altervista.org/2012/excel-vba-or-formula-combine-2-columns/
Source: http://www.pcreview.co.uk/forums/combine-2-columns-using-vba-t3910210.html
Language: English

View more articles on: http://www.heelpbook.net/
Follow us on Facebook: http://it-it.facebook.com/pages/HeelpBook/100790870008832
Follow us on Twitter: https://twitter.com/#!/HeelpBook
Follow us on RSS Feed: http://feeds.feedburner.com/Heelpbook
Follow us on Delicious: http://delicious.com/heelpbook