How do I link two columns of data into one column?
I've done this before but can't remember the solution. I have two columns of
date: Column A contains first names, Column B conains last names. I created column C for the combined contents of A and B. I also want the data separated by a space. I understand that if I want to combine the contents of two cells, I could use the formula =A1&" "&B1. But how do I do this for entire columns with a range of approximately 1,000 cells? I am not a heavy user of excel, so please keep the answers simple. Thank you. |
How do I link two columns of data into one column?
Hi Baylynx
=se this formula =a1&" "&b1 and copy it down HTH regards from Brazil - going to the 6th * Marcelo "Baylynx" escreveu: I've done this before but can't remember the solution. I have two columns of date: Column A contains first names, Column B conains last names. I created column C for the combined contents of A and B. I also want the data separated by a space. I understand that if I want to combine the contents of two cells, I could use the formula =A1&" "&B1. But how do I do this for entire columns with a range of approximately 1,000 cells? I am not a heavy user of excel, so please keep the answers simple. Thank you. |
How do I link two columns of data into one column?
In C1, type =*A1 & " " & B1* Now hover your cursor over the bottom right hand corner of cell C1 and you will see the cursor change to a cross. Now either: 1. click (& hold) and drag downwards to copy the formular down the page OR (and this is good) 2. double click the cross! This last one depends on you using good Excel practice which is no blank rows or columns in your data otherwise strange - and very irritating - things can happen. HTH Martin -- MartinShort Software Tester ------------------------------------------------------------------------ MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034 View this thread: http://www.excelforum.com/showthread...hreadid=553792 |
How do I link two columns of data into one column?
I'm sorry Marcelo, but I don't understand =se this formula. Can you please
explain further? Thank you. "Marcelo" wrote: Hi Baylynx =se this formula =a1&" "&b1 and copy it down HTH regards from Brazil - going to the 6th * Marcelo "Baylynx" escreveu: I've done this before but can't remember the solution. I have two columns of date: Column A contains first names, Column B conains last names. I created column C for the combined contents of A and B. I also want the data separated by a space. I understand that if I want to combine the contents of two cells, I could use the formula =A1&" "&B1. But how do I do this for entire columns with a range of approximately 1,000 cells? I am not a heavy user of excel, so please keep the answers simple. Thank you. |
How do I link two columns of data into one column?
sorry Baylynx it was a typing error
it means use =A1&" "&B1 and copy it down for the 1000 rows "Baylynx" escreveu: I'm sorry Marcelo, but I don't understand =se this formula. Can you please explain further? Thank you. "Marcelo" wrote: Hi Baylynx =se this formula =a1&" "&b1 and copy it down HTH regards from Brazil - going to the 6th * Marcelo "Baylynx" escreveu: I've done this before but can't remember the solution. I have two columns of date: Column A contains first names, Column B conains last names. I created column C for the combined contents of A and B. I also want the data separated by a space. I understand that if I want to combine the contents of two cells, I could use the formula =A1&" "&B1. But how do I do this for entire columns with a range of approximately 1,000 cells? I am not a heavy user of excel, so please keep the answers simple. Thank you. |
All times are GMT +1. The time now is 06:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com