Coping part of a cell content into a seperate cell
in [General]
|
From: Caz H on 14 Apr 2010 11:01 Hi I have two cells, one containing first and middle name and another one with surname. I want to combine the first name and surname into a separate cell, can you advise how I can just copy the first name and miss out the middle name please?? Thanks Caz
From: Eduardo on 14 Apr 2010 11:10 Hi, I assume that the midle name is separated by a space from the first name and is in column A and the last name in column B =TRIM(LEFT(A2,FIND(" ",a2)-1))&" "&B2 "Caz H" wrote: > Hi > I have two cells, one containing first and middle name and another one with > surname. I want to combine the first name and surname into a separate cell, > can you advise how I can just copy the first name and miss out the middle > name please?? > > Thanks > > Caz >
From: stumac on 14 Apr 2010 11:18 Hi Caz, I assume not everyone will have a middle name, try something like: =IF(ISERROR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))&" "&B1 Where the forename is in cell A1 and the surname is in cell A2. Hth Stu "Caz H" wrote: > Hi > I have two cells, one containing first and middle name and another one with > surname. I want to combine the first name and surname into a separate cell, > can you advise how I can just copy the first name and miss out the middle > name please?? > > Thanks > > Caz >
From: stumac on 14 Apr 2010 11:21 ...........That should read - the surname is in cell B1! "stumac" wrote: > Hi Caz, I assume not everyone will have a middle name, try something like: > > =IF(ISERROR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))&" "&B1 > > Where the forename is in cell A1 and the surname is in cell A2. > > Hth > > Stu > > > > "Caz H" wrote: > > > Hi > > I have two cells, one containing first and middle name and another one with > > surname. I want to combine the first name and surname into a separate cell, > > can you advise how I can just copy the first name and miss out the middle > > name please?? > > > > Thanks > > > > Caz > >
|
Pages: 1 Prev: Include a value from one cell within text of another cell. Next: Cell Border Symbols |