combining information

[noel]

is there a way to combine information from two cells into
one cell for example we want to combine name and address
which at present are in two cells into one cell that
contains both name and address.

thanks

 

[Paul B]

noel, here is one way =A1&" "&B1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **