18 Apr 2008 at 16:18 #1 Nefarious Nefarious Associate Joined 1 Aug 2003 Posts 1,053 Sorry for the simple question but.... How do I get a cell to display the text from several different cells? e.g. I have first name and surname in cols A and B and want C to be Surname, First Name Ta!
Sorry for the simple question but.... How do I get a cell to display the text from several different cells? e.g. I have first name and surname in cols A and B and want C to be Surname, First Name Ta!
18 Apr 2008 at 16:43 #2 RobH RobH Soldato Joined 9 May 2005 Posts 4,530 Location Nottingham Assuming A1 contains the first name and B1 contains the last name: =B1&", "&A1 OR =CONCATENATE(B1,", ",A1) Both will work, don't think it makes any difference which one you use. Last edited: 18 Apr 2008
Assuming A1 contains the first name and B1 contains the last name: =B1&", "&A1 OR =CONCATENATE(B1,", ",A1) Both will work, don't think it makes any difference which one you use.
