You mean you want to see "&" in the result?
Please give us examples on inputs and desired output
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Beginner2005" wrote in message
...
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