+ Reply to Thread
Results 1 to 8 of 8

Fill series combination of text and numbers

  1. #1
    Registered User
    Join Date
    11-29-2011
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    41

    Fill series combination of text and numbers

    Hello,

    I have this IDs with empty rows and I need to fill in series, it only works when you drag the value and I have around ten thousand lines.
    Formula or function to fill in empty rows are highly appreciated.

    Capture.PNG

    Thanks a lot!
    Attached Files Attached Files
    Last edited by spishowtime; 09-05-2018 at 05:15 AM. Reason: add photo so you dont need to download

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Fill series combination of text and numbers

    Will the ID's always consist of 2 letters and 3 numbers?

    BSB

  3. #3
    Registered User
    Join Date
    11-29-2011
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: Fill series combination of text and numbers

    Quote Originally Posted by BadlySpelledBuoy View Post
    Will the ID's always consist of 2 letters and 3 numbers?

    BSB
    I checked the ids and they are random some have long letters and long numbers

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,890

    Re: Fill series combination of text and numbers

    Here is one way of achieving this, using two helper columns (which can be hidden, or even be on another sheet).
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Registered User
    Join Date
    11-29-2011
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: Fill series combination of text and numbers

    Quote Originally Posted by Glenn Kennedy View Post
    Here is one way of achieving this, using two helper columns (which can be hidden, or even be on another sheet).
    Thanks a lot Glenn Kennedy highly appreciate it!

  6. #6
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Fill series combination of text and numbers

    Hi,

    Here's another formula to consider, without helper columns, in B2 copied down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-29-2011
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: Fill series combination of text and numbers

    Quote Originally Posted by jtakw View Post
    Hi,

    Here's another formula to consider, without helper columns, in B2 copied down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached.
    Also works, thanks too jtakw!

  8. #8
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Fill series combination of text and numbers

    You're welcome, thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Fill Series with Number + Text
    By Cnoe in forum Excel General
    Replies: 3
    Last Post: 12-09-2015, 03:58 PM
  2. Fill Handle and Series of Numbers Help Please
    By Badbob94 in forum Excel General
    Replies: 2
    Last Post: 12-08-2015, 12:15 PM
  3. Replies: 4
    Last Post: 11-20-2013, 10:16 PM
  4. Replies: 2
    Last Post: 10-11-2012, 08:31 AM
  5. How to fill series of numbers in excel
    By narendrabr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2012, 01:09 AM
  6. use fill series alphabet with numbers but with Filter on
    By matdog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2010, 03:09 AM
  7. [SOLVED] Combination text & numbers - use what format for pivot
    By Amy in forum Excel General
    Replies: 2
    Last Post: 06-14-2006, 01:10 PM

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