Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
new user concantate 2 columns 479 rows?
completely confused. need to concantate 2 columns of 479 rows to combine
first and last names. using 2007 excel. how do I do this simple task, without having to do each row seperatly? Please note I am not a proficient user, so plain text please!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
new user concantate 2 columns 479 rows?
Assuming your first name is in column A, and your last name is in column B,
and your columns have headings, in C2 enter: =a2&" "&b2 With this cell still highlighted, double click on the fill box (the small square on the bottom right of the box). Regards, Fred. "louisaprice" wrote in message ... completely confused. need to concantate 2 columns of 479 rows to combine first and last names. using 2007 excel. how do I do this simple task, without having to do each row seperatly? Please note I am not a proficient user, so plain text please!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
User Choosing Which Columns to View | Excel Discussion (Misc queries) | |||
Hide columns to all but one user? | Excel Discussion (Misc queries) |