OT MS Excel

=CONCATENATE(A1," ",B1) A1= first name " " = space B1 = last name

Shirley Graver
Systems Administrator
Rubber Associates Inc.
Cleveland/Akron, OH

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Thursday, March 14, 2002 9:25 AM
To: Vantage List (E-mail)
Subject: [Vantage] OT MS Excel


I have a simple problem in MS Excel that I cannot figure out. I have a
first name column and a
last name column. I want to combine the first name and last name into one
column. I thought I
have done this before but after poking and prodding around I cannot figure
out how to do this.
Anyone know the trick?

Thanks

Todd Hofert
Spartan Graphics, Inc.
(616)887-8243


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I have a simple problem in MS Excel that I cannot figure out. I have a first name column and a
last name column. I want to combine the first name and last name into one column. I thought I
have done this before but after poking and prodding around I cannot figure out how to do this.
Anyone know the trick?

Thanks

Todd Hofert
Spartan Graphics, Inc.
(616)887-8243
In a third column: =A1&" "&B1



[Non-text portions of this message have been removed]
Or you can use the @concatenate function. In the third column you would have @concatenate(A1,B1).

----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Thursday, March 14, 2002 9:37 AM
Subject: RE: [Vantage] OT MS Excel


In a third column: =A1&" "&B1



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
Awesome. I knew it was simple. I think everyone on the list knew this.

Thanks

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, March 14, 2002 9:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT MS Excel


In a third column: =A1&" "&B1



[Non-text portions of this message have been removed]



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/