Excel 2007 : multiple cell text data entry to a single cell

Hi guys, I just want to know if there is a way where I can combine text data in three separate cells in one cell in another sheet?

for example:
first cell: Brown
second cell: James
third cell: T.

destination cell would be: Brown, James T.

is this possible? thanks in advance!

Please Login or Register  to view this content.

Try:

=A1&", "&B1&" "&C1

where A1, B1 and C1 contain the text to concatenate.