how do you add a space when merging text using & ?
 

how do you add a space when merging text using & ?
 

=A1 & " " & B1


"eddie" wrote in message
...

how do you add a space when merging text using & ?
 

=A1&" "&B1

[And next time, please ask your question in the body of the message, not
just in the subject line. Blank messages will often be rejected or
ignored.]
--
David Biddulph

"eddie" wrote in message
...