Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Link a horizontal row of data to a column in another wrksh. | Excel Discussion (Misc queries) | |||
Macro to compare two columns of data | Excel Discussion (Misc queries) | |||
Excel link to data in other worksheet only refreshes one column | Excel Discussion (Misc queries) | |||
how to put data in the column A to the next row of the column B | Excel Discussion (Misc queries) | |||
Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) |