combine columns
 

I am creating reports from a precreated excel document. my boss wants me to
take two columns and combine them Example column A is last name and Column B
is first name. She wants it to read last, first name. if it was a small doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

combine columns
 

Assuming that data begins in row 2, enter this formula in cell C2:
=A2 & ", " & B2
and copy down for as many rows as there are entries in Cols A and B.
--
TedMi

"Darrell_Sarrasin via OfficeKB.com" wrote:

I am creating reports from a precreated excel document. my boss wants me to
take two columns and combine them Example column A is last name and Column B
is first name. She wants it to read last, first name. if it was a small doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

combine columns
 

hi,

First name in a1
Second name in b1
this in c1
=B1&" "&A1

Double click the fill handle and ut will fill down as far as column B is
populated.

Mike

"Darrell_Sarrasin via OfficeKB.com" wrote:

I am creating reports from a precreated excel document. my boss wants me to
take two columns and combine them Example column A is last name and Column B
is first name. She wants it to read last, first name. if it was a small doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

combine columns
 

Try this

in C1 put this formula =A1&","&B1 and drag it till u need.



On Sep 23, 8:49*am, "Darrell_Sarrasin via OfficeKB.com" <u33691@uwe
wrote:
I am creating reports from a precreated excel document. *my boss wants me to
take two columns and combine them *Example column A is last name and Column B
is first name. *She wants it to read last, first name. *if it was a small doc
would not be bad but we have 10000 entries in the form. *please help.

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200809/1

combine columns
 

In an un-used column enter:
=A1 & ", " & B1 and copy down

Then take the new column, copy it, and paste/special/values back onto column
A.
--
Gary''s Student - gsnu2007k


"Darrell_Sarrasin via OfficeKB.com" wrote:

I am creating reports from a precreated excel document. my boss wants me to
take two columns and combine them Example column A is last name and Column B
is first name. She wants it to read last, first name. if it was a small doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

combine columns
 

Sub lastfirst()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
lastrow = Cells(Rows.Count, "a").End(xlUp).Row
For Each c In Range("a2:a" & lastrow)
c.Value = c & ", " & c.Offset(, 1)
Next c
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic

End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8a9f5043a4e79@uwe...
I am creating reports from a precreated excel document. my boss wants me
to
take two columns and combine them Example column A is last name and
Column B
is first name. She wants it to read last, first name. if it was a small
doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

combine columns
 

can this be manipulated so the results show in column c and does not effect
the first name?

Don Guillett wrote:
Sub lastfirst()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
lastrow = Cells(Rows.Count, "a").End(xlUp).Row
For Each c In Range("a2:a" & lastrow)
c.Value = c & ", " & c.Offset(, 1)
Next c
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic

End Sub

I am creating reports from a precreated excel document. my boss wants me
to
[quoted text clipped - 3 lines]
doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

combine columns
 

If I understand, you have last in col a, first in col b and you want both in
col c. You probably should have been able to figure this out yourself.
c.offset(,2) = c & ", " & c.Offset(, 1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8aae6e304f5cf@uwe...
can this be manipulated so the results show in column c and does not
effect
the first name?

Don Guillett wrote:
Sub lastfirst()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
lastrow = Cells(Rows.Count, "a").End(xlUp).Row
For Each c In Range("a2:a" & lastrow)
c.Value = c & ", " & c.Offset(, 1)
Next c
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic

End Sub

I am creating reports from a precreated excel document. my boss wants me
to
[quoted text clipped - 3 lines]
doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1