Merge Cells

R

R. Stevens

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.
 
D

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.
 
Top