| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to merge 2 + contiguous cells without lossing data?
I need to merge two or more contiguous cells without lossing the data.
Also I have cells that I copied & pasted into cells and I am unable to add data to these cells. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to merge 2 + contiguous cells without lossing data?
Hi Patti
To concatenate two cells, it can be done this way : =A1&B1 this will merge A1 with B1. If you want space between words; =A1&" "&B1 You can concatenate has many cells as you like, or had words like this =A1&" "&B1&" "&Last Word" HTH John "Patti" wrote in message ... I need to merge two or more contiguous cells without lossing the data. Also I have cells that I copied & pasted into cells and I am unable to add data to these cells. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to merge 2 + contiguous cells without lossing data?
Correction to the last example, missing double quote
=A1&" "&B1&" "&"Last Word" John "John" wrote in message ... Hi Patti To concatenate two cells, it can be done this way : =A1&B1 this will merge A1 with B1. If you want space between words; =A1&" "&B1 You can concatenate has many cells as you like, or had words like this =A1&" "&B1&" "&Last Word" HTH John "Patti" wrote in message ... I need to merge two or more contiguous cells without lossing the data. Also I have cells that I copied & pasted into cells and I am unable to add data to these cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge cells with same data | Excel Discussion (Misc queries) | |||
| Merge Two Cells and Keep all Data | Excel Discussion (Misc queries) | |||
| merge cells that contain the same data | Excel Discussion (Misc queries) | |||
| Paste Data into Contiguous (Visible) Cells | New Users to Excel | |||
| Can I create an Excel chart from non-contiguous data cells? | Charts and Charting in Excel | |||
Linear Mode
