Sorry in advance if I don't explain this very well, definite newbie here when it comes to spreadsheets.
I have a Text only spreadsheet with 4 columns, first 3 are Student's Last name, First name, and Class. 4th column will be concatenate of the other columns. I'm using this formula
=CONCATENATE(A2;" ";B2;" ";C2;".jpg")
I'm using this to create file names for student photos, hence the .jpg and yes I do want the output to have spaces in between, eg. John Smith Senior.jpg The problem I have is duplicating the formula throughout the column and have the Row # change. I can duplicate it now, by click-dragging the bottom right corner of the cell, but Row #'s don't change. Need help with this! Don't wish to go through hundreds of rows and manually change the formula!
Thanks for any help!