A1 = John

B1 = Smith


C1=A1&" "&B1

C1 will show John Smith


If it was an address and you wanted to put 45 Brown Street, Your Town
(note the ,) you would put the , between the ", "


Regards


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/