| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel 3 column merge
I have an excel file with 4,000 rows and 15 columns. I need to merge three
columns so I created a new column for the merged data. Entered formula =M1&","&N1&"/"&O1 and that worked as intended for first row. How do I apply formula to remaining 3,999 rows? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel 3 column merge
One way:
Copy the first cell. Select the remaining cells in which the formulae are to appear (i.e., in a column). Paste. In article , flaglernet wrote: I have an excel file with 4,000 rows and 15 columns. I need to merge three columns so I created a new column for the merged data. Entered formula =M1&","&N1&"/"&O1 and that worked as intended for first row. How do I apply formula to remaining 3,999 rows? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I merge 4 excel columns to 1 column (street,city,st,zip | Excel Discussion (Misc queries) | |||
| merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
| In Excel 07, how do I merge two sprdshts with a common column? | Excel Worksheet Functions | |||
| Excel +won't +merge cells in a column. Is my formatting blocking . | New Users to Excel | |||
| Excel, when column A and B have same name make column C add up in mail merge | Excel Discussion (Misc queries) | |||
Linear Mode
