Thanks for all your help guys but no joy, excel still wont allow the 'amp'
parts of the formula to be recognised. Does it sound like i may be doing
something wrong here?




"Jed" wrote:

c1=(a1&" "&b1) (note space between quotes)
"Beginner2005" wrote in message
...
Hi
have formula in cell c1{ =a1&b1} which copies the words from both cells
and
combines them, how do i put a space between the two copied words within
this
formula please?

any help for an amateur greatly appreciated.

thanks