+ Reply to Thread
Results 1 to 4 of 4

Incriminate numbers with in alphanumeric string

  1. #1
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    302

    Incriminate numbers with in alphanumeric string

    Hello Experts,

    All data are in one column starting cell are A1,A2,A3,A4,& A5 and so on
    task to me is increase numbers in between string in the following manner :-

    AUSY/200214/0001/01
    AUSY/200214/0002/01
    AUSY/200214/0003/01
    AUSY/200214/0004/01
    AUSY/200214/0005/01

    currently I copy A1 up to required say 30 cells and change manually...

    any suggestion/assistance appreciate,
    Thanks in advance

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,368

    Re: Incriminate numbers with in alphanumeric string

    Maybe...

    ="AUSY/200214/"&TEXT(ROWS($A$1:A1),"0000")&"/01" and copied down

  3. #3
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Incriminate numbers with in alphanumeric string

    Type formula in cell a1 = "Ausy/200214/"&"000"&rows ($ A$1:A1)&"/01"

  4. #4
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    302

    Re: Incriminate numbers with in alphanumeric string

    Hi Azumi & Thameem127,
    Both suggested functions works brilliantly!
    Thanks a lot for solutions
    Cheer
    Karnik

+ 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. Extracting Numbers from a Alphanumeric String
    By martinhardy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2013, 11:02 AM
  2. Extracting Numbers from an Alphanumeric String
    By martinhardy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2013, 04:53 PM
  3. [SOLVED] Adding leading zero to numbers within alphanumeric string
    By jp78kt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2013, 05:38 PM
  4. [SOLVED] Remove numbers from alphanumeric string. No standard format to the string.
    By ricunger in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2012, 01:43 PM
  5. Extracting Text/Numbers from an AlphaNumeric String.
    By e4excel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-05-2010, 01:48 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