excel 3 column merge

F

flaglernet

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?
 
J

JE McGimpsey

One way:

Copy the first cell. Select the remaining cells in which the formulae
are to appear (i.e., in a column). Paste.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete a formula but leave the data. 2
Merging multiple columns into one column (dynamically) 1
merging multple columns into one column (dynamically) 2
Excel Subtracting multiple columns from another column 3
Need Help Merging Cells 2
Comparing 3 Columns and Returning a Result 2
Excel 2013 Merge Data 2
Tax Form with Merge and Center 7

Top