Results 1 to 7 of 7

Separate Number Suffix?

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    Raleigh, NC
    MS-Off Ver
    2007
    Posts
    2

    Separate Number Suffix?

    I have a data set that has various numbers with suffixes (1 PC, 1 PAC, 1 CV, etc.). The suffixes are generated by custom number formatting. The issue I have is that certain suffixes (such as PC and CV) indicate a x1 value, while others (such as PAC) indicate a different multiple, such as x3 in this case.

    I have tried =right, =text, and text to columns, but because it is a part of the format and not data in the cell the suffix isn't recognized. Also why conditional formatting won't work. is there any way to separate the suffix from the number or otherwise identify the items that need a different value?

    Simple example attached. Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Separating lastname + suffix to separate columns
    By 2by4 in forum Excel General
    Replies: 6
    Last Post: 03-20-2014, 01:12 AM
  2. [SOLVED] Number Suffix Question
    By VTJeep in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-15-2014, 10:28 AM
  3. [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
  4. [SOLVED] adding unique number suffix
    By hmm321 in forum Excel General
    Replies: 2
    Last Post: 07-01-2012, 05:25 PM
  5. [SOLVED] What does a number with suffix # mean?
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2005, 12:05 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