[RESOLVED] Combine 2 columns in EXCEL

Sarah, Michaeel, Todd, Wayne,

Thanks for the help! Worked like a charm.


-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, January 10, 2002 9:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [OT] Combine 2 columns in EXCEL

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
>>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

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:
(2) To search through old msg's goto:
(3) To view links to Vendors that provide Vantage services goto:

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/