If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|