| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
| How can I merge unlocked cells in a worksheet that has been protec | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| Cells losing formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
