Combine text data from 2 cells
 

simple question
a1 has brad
b1 has glaberson
i want c1 to be brad glaberson
what is the formula, please

thanks
brad

Combine text data from 2 cells
 

Brad,

=CONCATENATE(A1," ",B1)

or

=A1&" "&B1

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=542267

Combine text data from 2 cells
 

Try this:

C1: =A1&" "&B1

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Brad" wrote:

simple question
a1 has brad
b1 has glaberson
i want c1 to be brad glaberson
what is the formula, please

thanks
brad

Combine text data from 2 cells
 

Perfect!!!
thanks guys

"SteveG" wrote:


Brad,

=CONCATENATE(A1," ",B1)

or

=A1&" "&B1

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=542267