Merge Cells

[Guest]

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.

 

[Dave R.]

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.

 

[Frank Kabel]

Hi
=A1 & " " & B1