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

=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

=a1&" "&b1

--
Don Guillett
SalesAid Software

"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

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

Hi Bernard
Thanks for your help, i have tried this previously but Excel does not like
the first &amp 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

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

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