Getting data from 2 differant colums
 

How do you get data from 2 differant columns to be in 1 other column.
I have a column First Name and a Column Last name I want Column Full Name to
automaticlly update with the first 2 columns

Getting data from 2 differant colums
 

Try this...

A1 = FirstName
B1 = LastName

Enter this formula in C1 to combine them with a space character between
manes:

=A1&" "&B1

Returns: FirstName LastName

--
Biff
Microsoft Excel MVP


"Kelly********" wrote in message
...
How do you get data from 2 differant columns to be in 1 other column.
I have a column First Name and a Column Last name I want Column Full Name
to
automaticlly update with the first 2 columns