I have a bunch of data in columns with each row representing a location. Rather than use a grid coordinate to reference each location I would like to assign each on an admin number (OH-0001, OH-0002, OH-0003, etc). I tried the standard type it in and drag down and excel won't continue the pattern, it just duplicated the numbers I've already typed in. There are close to a thousand of these values so I would really prefer to not type each number. Your help is really appreciated!