Autofill sequentially from the right-hand number in a cell
Using Excel 2011 for Mac. I have a column that needs to be renamed in sequential order. The content are the names of photographs. The text in a cell goes as follows… PROJECTNUMBER PROJECTNAME PHOTONUMBER So a single cell looks like this… 1234 ANTONIO 001 I need keep the PROJECTNUMBER the same and have the number on the right-hand side, PHOTONUMBER, go sequentially from 001 to 1049. When I drag the cell down from the right-hand corner, the PROJECTNUMBER goes sequentially rather than the PHOTONUMBER. How can I get the PHOTONUMBER to go sequentially? Thanks!
