+ Reply to Thread
Results 1 to 2 of 2

formula to add a varying suffix to a fixed number

  1. #1
    Registered User
    Join Date
    12-10-2012
    Location
    Oxford
    MS-Off Ver
    Excel 2000
    Posts
    10

    formula to add a varying suffix to a fixed number

    I have an invoice with a fixed number - (9500 for sake of argument) on the first sheet of my workbook.

    The invoice is payable in monthly instalments so I have the monthly invoices on the following worksheets.

    I would like the invoice for the first month to be 9500a, the second sheet 9500b and so on. Is there a formula that can add to each sheet to add the alphabetic suffix to the fixed cell (and number) which is on the front sheet.

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: formula to add a varying suffix to a fixed number

    Something like this: =9500&CHAR(96+SHEET())
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. Formula to copy a number from a cell and make the number fixed
    By Brycker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-29-2015, 01:59 PM
  2. How to add suffix to cell in an fixed interval
    By GuyMor in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-08-2014, 05:49 PM
  3. Formula to calculate next number in sequence based on varying criteria
    By Twaddy006 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2014, 05:53 PM
  4. macro to import varying data rows into fixed table
    By aselly22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2014, 12:51 AM
  5. [SOLVED] Changing a positive or negative value based on the input's suffix, then removing suffix
    By Theredwind in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2014, 05:19 AM
  6. [SOLVED] Formula with non fixed row number
    By shardin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2013, 06:51 PM
  7. Excel formula for SUM of Varying number of Rows in a Particular column
    By Manoj1551 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2011, 08:12 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