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 |