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!
="oh-"&text(rows($a$1:a1),"0000")
mind you if
call a1= oh-0001
cell a2 =oh-0002
select both and drag down gives
oh-0001
oh-0002
oh-0003
oh-0004
oh-0005
oh-0006
oh-0007
oh-0008
Last edited by martindwilson; 12-01-2012 at 05:48 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try this one
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
hi ENeos07, try:
="OH-"&TEXT(ROW(1:1),"0000")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
@ oeldere row() would change ,depends where you put it and op asked for 4 not 3 digits at end
@Martin
Thanks for the adjustment about the row(); OK 4 instead of 3 digits.Please Login or Register to view this content.
Thank you for all of your quick replies!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks