Welcome To Signs101.com: Largest Forum for Signmaking Professionals

Signs101.com: Largest Forum for Signmaking Professionals is the LARGEST online community & discussion forum for professional sign-makers and graphic designers.


  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

number sequence

Discussion in 'Tips & Tricks' started by New Vision Signworks, Jan 22, 2020.

  1. New Vision Signworks

    New Vision Signworks Member

    Apr 26, 2011
    Dana Point
    Hey Guys, I need to make a bunch of labels that go from P20001 to P20150

    I use Illustrator, whats the best way of doing this

    they are going to be printed and kiss cut rectangles 3/4"x1.5"

  2. unclebun

    unclebun Very Active Member

    It's a lot easier in Corel Draw because it can all be done within Corel Draw. But in Illustrator you can use Excel and do a data merge. Google sequential numbering in illustrator and you'll find numerous Youtube videos showing how.
  3. eahicks

    eahicks Magna Cum Laude - School of Hard Knocks

    Apr 17, 2012
    Flexi is even easier if you have it.
  4. Boudica

    Boudica I'm here for educational purposes.

    Dec 21, 2018
    WA State
    What RIP are you using? This can be done in several programs like INDD, AI (I would assume Corel as mentioned above). It can also be done in VW or Onyx. The terminology your looking for is "Variable Data". You can look up how to merge variable data for the software you decide to use.
  5. Bobby H

    Bobby H Very Active Member

    Feb 4, 2005
    Lawton, OK
    There's a couple things I don't like about the data merge and print merge methods for CorelDRAW and Adobe InDesign. Each number object is created on a different page. There doesn't appear to be any easy or quick way to auto-generate a sequential series of separate numbered objects on the same page or art board. Copying and pasting from a spreadsheet or text file appears to be the most direct way in CorelDRAW.

    I like being able to see all the numbered items on the same page to see (and fix) number spacing issues more easily. I don't like the default tabular lining figures that are likely to flow in from a separate program, be it Excel, Word Pad or even Notepad. Numbers with tabular lining often have ugly spacing gaps, particularly around the number 1. If you can select all the numbers at once on the same page they can all be changed from tabular lining to proportional lining in just a couple clicks. Proportional lining figures look a lot better for numbered signs. Default tabular lining is best for multiple numbered objects containing two or more numbers each are stacked above each other in lists or equations. Great for spreadsheets, but usually not so great on signs. Not all fonts contain proportional lining figures (or old style figures, numerators, denominators, etc).

    If you're printing, cutting or doing a bit of both it's nice to be able to have more visual control over how the objects are arranged (or nested) before they're print or cut.
  6. unclebun

    unclebun Very Active Member

    I would never do data merge for making signs like house numbers. Lay those out individually. I only use data merge for things like parking permits or tickets which have to be numbered. Centering or left aligned comes out fine, particularly since they tend to be 3 or 4 digit numbers or more.
  7. shoresigns

    shoresigns Very Active Member

    Nov 1, 2011
    Vancouver, BC
    • Like Like x 1
  8. FireSprint.com

    FireSprint.com Trade Only Screen & Digital Sign Printing

    +1 for shoresigns way - interesting. We use the InDesign merge feature.