Hi Bernard
Thanks for your help, i have tried this previously but Excel does not like
the first & in the formula
any ideas???
"Bernard Liengme" wrote:
=A1&" "&B1"
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"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