Use
=A1&" "&B1

the " " is showing that you want to insert text, and that the text is a
space character. It could be "-" or ".", etc.


"R. Stevens" <R. wrote in message
...
I know how to merge two cells using formula =A1&B1, but can someone tell
me
how to insert spacing between the two within the new cell. I'm merging a
part number and description, and need spacing between them.