Results 1 to 2 of 2

Help with Autofill Pattern: S/N: XQ3017-1, XQ3018-1, XQ3019-1

Threaded View

  1. #1
    Registered User
    Join Date
    10-30-2015
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    6

    Help with Autofill Pattern: S/N: XQ3017-1, XQ3018-1, XQ3019-1

    I need some help formatting the above mentioned pattern. I figured out how to do this over a year ago, but like the dummy I am forgot to save the instructions!

    I seem to recall having to enter a formula, but I'm not sure. This is the formatting that I need:

    FLAIR
    MODEL SN-580-24-AB
    Serial Number: XQ3017-1

    FLAIR
    MODEL SN-580-24-AB
    Serial Number: XQ3018-1

    FLAIR
    MODEL SN-580-24-AB
    Serial Number: XQ3019-1

    FLAIR
    MODEL SN-580-24-AB
    Serial Number: XQ3020-1

    FLAIR
    MODEL SN-580-24-AB
    Serial Number: XQ3021-1

    Each line is in a separate cell. If anyone knows how to use autofill to continue this sequence of numbers, I'll be eternally grateful!

    Thank you
    Last edited by flairelectronics; 02-07-2017 at 03:34 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Autofill Pattern
    By amedeo in forum Excel General
    Replies: 2
    Last Post: 06-22-2015, 08:36 PM
  2. [SOLVED] Autofill not recognizing pattern
    By WILLPOU in forum Excel General
    Replies: 4
    Last Post: 11-05-2013, 11:24 PM
  3. [SOLVED] Autofill not following pattern of the cells.
    By jgcramer in forum Excel General
    Replies: 3
    Last Post: 05-14-2013, 12:55 AM
  4. Using AutoFill a number pattern without the mouse
    By Fieldsinc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-11-2012, 10:33 PM
  5. [SOLVED] Excel does not recognize autofill pattern
    By myexcelquestions in forum Excel General
    Replies: 5
    Last Post: 06-14-2012, 08:41 AM
  6. [SOLVED] Autofill reference pattern
    By kbka in forum Excel General
    Replies: 2
    Last Post: 06-06-2012, 04:58 AM
  7. autofill cells without a pattern?
    By ryu in forum Excel General
    Replies: 2
    Last Post: 04-11-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1