Combine text data from 2 cells

[Brad]

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

thanks
brad

[SteveG]

Brad,

=CONCATENATE(A1," ",B1)

or

=A1&" "&B1

HTH

Steve

[Brad]

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

[Ron Coderre]

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