duplicate effort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used concatenate function for the first row. Now the same function has to
be applied to the 1500 rows below it. Is there a way in which i dont have to
do it manually 1500 times?
 
Assuming you didn't use absolute references, one way:

Copy the first cell. Select cells in the next 1499 rows. Paste.
 
Back
Top