=A1 & " " & B1 where A1 contains First name and B1 contains Last Name


e.g.

A1=Joe
B1=Bloggs
C1=Joe Bloggs

HTH

"djarcadian" wrote:


I want to take data from multiple cells and display it as one. For
example, we'd have a cell which will have the persons first name and
another cell with the persons last name. Then, we'd have one cell that
would take the first and last name and display it in one cell. How do I
do this? Thanks in advance!


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=546851