Merge Cells
 

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.

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.

Hi
=A1 & " " & B1

--
Regards
Frank Kabel
Frankfurt, Germany
"R. Stevens" <R. schrieb im Newsbeitrag
...
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.