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

Merging from an Excel file with graphics 1
Need help merging Excel into Publisher Booklet w 2 columns 0
Booklet in Word, Merge Directory from Excel 0
Autonumber field in Excel that behaves the same as Access 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Need Help with a VBA subroutine 0
Page numbering with Merged Document and IF statements 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top