How to merge 2 + contiguous cells without lossing data?
in [General]
|
From: Patti on 4 Jun 2010 12:14 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.
From: John on 4 Jun 2010 14:18 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" <Patti(a)discussions.microsoft.com> wrote in message news:F8599A17-9C76-4C83-A42E-EBE9358DDE1E(a)microsoft.com... >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.
From: John on 4 Jun 2010 14:25 Correction to the last example, missing double quote =A1&" "&B1&" "&"Last Word" John "John" <johnd(a)newlook.com> wrote in message news:O3hkXJBBLHA.4704(a)TK2MSFTNGP06.phx.gbl... > 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" <Patti(a)discussions.microsoft.com> wrote in message > news:F8599A17-9C76-4C83-A42E-EBE9358DDE1E(a)microsoft.com... >>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. >
|
Pages: 1 Prev: Sorting a list of numbers Next: nested formulas in excel using iserror and if |