D Debra Oct 16, 2003 #1 I a spreadsheet with first name in one column and last name in the next column. How can I put them together in one column?
I a spreadsheet with first name in one column and last name in the next column. How can I put them together in one column?
C Chip Pearson Oct 16, 2003 #2 Debra, You can use the & operator to combine multiple strings in to a single string .. E.g., =A1&B1 or, with an embedded space, =A1&" "&B1 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
Debra, You can use the & operator to combine multiple strings in to a single string .. E.g., =A1&B1 or, with an embedded space, =A1&" "&B1 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
F Felipe Oct 16, 2003 #3 Debra, Assuming first name is in column A and last name is in column B. Type the following in C1: =A1&" "&B1 And copy down the formula You can also use the CONCATENATE function: =CONCATENATE(A1," ",B1) Regards, Felipe
Debra, Assuming first name is in column A and last name is in column B. Type the following in C1: =A1&" "&B1 And copy down the formula You can also use the CONCATENATE function: =CONCATENATE(A1," ",B1) Regards, Felipe
D Debra Oct 16, 2003 #4 Fabulous! Thanks very much! -----Original Message----- Debra, Assuming first name is in column A and last name is in column B. Type the following in C1: =A1&" "&B1 And copy down the formula You can also use the CONCATENATE function: =CONCATENATE(A1," ",B1) Regards, Felipe . Click to expand...
Fabulous! Thanks very much! -----Original Message----- Debra, Assuming first name is in column A and last name is in column B. Type the following in C1: =A1&" "&B1 And copy down the formula You can also use the CONCATENATE function: =CONCATENATE(A1," ",B1) Regards, Felipe . Click to expand...
