Results 1 to 4 of 4

formula to replace numbers with specific letters

Threaded View

SPCC formula to replace numbers... 09-01-2020, 09:33 PM
wk9128 Re: formula to replace... 09-01-2020, 11:51 PM
SPCC Re: formula to replace... 09-02-2020, 01:20 PM
Bo_Ry Re: formula to replace... 09-02-2020, 02:22 AM
  1. 09-01-2020, 09:33 PM #1
    SPCC is offline
    Registered User
    Join Date
    10-03-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2003
    Posts
    2

    formula to replace numbers with specific letters

    Hi, I'm looking for a formula to replace numbers with letters, but the string of numbers varies and only the numbers before the hyphen need to be changed. Here are some examples;

    1135 would = AACE
    5567 would = EEFG
    23-804 would = BC-804
    111-0535 would = AAA-0535
    801-6654 would = HJA-6654

    Attached is a worksheet with more examples. Thanks in advance.
    Attached Files Attached Files
    Last edited by SPCC; 09-02-2020 at 01:23 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel won't allow me insert a specific string of letters/numbers without converting it
    By edatwork in forum Excel General
    Replies: 15
    Last Post: 02-17-2020, 11:21 AM
  2. [SOLVED] Average numbers after specific letters
    By jher001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-29-2017, 02:08 PM
  3. Formula Finding String with Specific Letters and Numbers
    By jpedges38 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-06-2012, 08:56 PM
  4. [SOLVED] Replace parts of a cell (Numbers and letters)
    By nicdyb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-19-2012, 08:15 AM
  5. Excel 2007 : Replace numbers by letters
    By pGrim in forum Excel General
    Replies: 4
    Last Post: 05-19-2011, 03:13 AM
  6. Count specific characters with numbers or letters
    By hoppscrouse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2007, 09:02 AM
  7. [SOLVED] replace the letters (for collumn) & numbers(row no.) of cell reference only
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2005, 12:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1