Excel Merging cells: Difference between revisions
Jump to navigation
Jump to search
New page: To merge 3 cells make a formula containing =A1&B1&C1 If you want spaces =A1&" "&B1&" "&C1 |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre> | |||
To merge 3 cells make a formula containing | To merge 3 cells make a formula containing | ||
=A1&B1&C1 | =A1&B1&C1 | ||
If you want spaces | If you want spaces | ||
=A1&" "&B1&" "&C1 | =A1&" "&B1&" "&C1 | ||
</pre> | |||
Latest revision as of 13:03, 21 January 2008
To merge 3 cells make a formula containing =A1&B1&C1 If you want spaces =A1&" "&B1&" "&C1