[OT] Combine 2 columns in EXCEL

Use the "Concatenate" function
This allows you to connect cells together

Don Kollmann
Heartland EPS

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, January 10, 2002 11:10 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] [OT] Combine 2 columns in EXCEL


A user has a first name column and a last name column that she would like to
combine into one full name column.

I can write a VB macro to do this, but there's got to be a way to do this
using the feature set in excel. She said she saw someone do it before.

Anyone know how?

Thanks in Advance,

Thaddeus

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
A user has a first name column and a last name column that she would like to
combine into one full name column.

I can write a VB macro to do this, but there's got to be a way to do this
using the feature set in excel. She said she saw someone do it before.

Anyone know how?

Thanks in Advance,

Thaddeus
In a third column, enter =A1&" "&B1, where A1 is the first name column and
b1 is the last name column.



[Non-text portions of this message have been removed]
At 12:15 PM 1/10/02 -0500, you wrote:
>>A user has a first name column and a last name column that she would like to
>>combine into one full name column.
-------
>In a third column, enter =A1&" "&B1, where A1 is the first name column and
>b1 is the last name column.

If they want a field with an actual value of the two merged, use the
formula suggested to concatenate the two. Then copy the column and do a
"past special" into another column. That will take the result of the
formula and turn it into a permanent, independent piece of data.

-Wayne Cox