Results 1 to 7 of 7

creating a series from alphanumeric data?

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2006
    Posts
    5

    creating a series from alphanumeric data?

    I've tried several things to accomplish this with no luck, but I'm sure it's not too tough to do:

    On my worksheet, I am entering columns of cells with alphanumeric data. The data are actually thousands of reference numbers that need to go in chronological order, with only the numerals changing (e.g., ABC0001DEF, ABC0002DEF, ABC0003DEF..., with "ABC" and "DEF" always the same).

    I can create a series just fine if I leave off the "DEF" part of the reference numbers (by selecting the first couple cells in the series and using the fill handle), but I can't get the same results with the numerals "nested" within the reference numbers (i.e., ABC####DEF).

    It sure would save me a lot of typing to be able to create a series to fill in all my reference numbers! Any ideas?
    Last edited by rykey; 09-11-2006 at 11:54 AM.

Thread Information

Users Browsing this Thread

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

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