Results 1 to 5 of 5

How to display particular digits from a text value, with one formula?

Threaded View

  1. 02-12-2021, 12:05 AM #1
    Dexter2
    Dexter2 is offline
    Forum Contributor
    Join Date
    12-25-2020
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    513

    How to display particular digits from a text value, with one formula?

    I have some numbers formatted as text to have a leading zero for particular values. I need to display particular digits as follows in the attached workbook. In the workbook, I use a mix of LEFT and MID functions, though I was wondering if I could have one formula being I work with different values?
    Attached Files Attached Files
    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] Looking for a formula to count single digits vs. double digits?
    By mnlaw in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-29-2023, 02:20 PM
  2. Excel Formula to extract last digits from text string
    By tunafishco in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-13-2017, 12:21 AM
  3. [SOLVED] Formula not returning desired number of digits after decimal, add text
    By Russ Fuquay in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-25-2013, 01:39 PM
  4. Formula to pickup Digits from a text sentanc and Add Zero at last if digit
    By tariqnaz2005 in forum Excel General
    Replies: 6
    Last Post: 01-17-2010, 08:44 AM
  5. display number >15 digits
    By SMILE in forum Excel General
    Replies: 8
    Last Post: 06-03-2008, 05:37 AM
  6. [SOLVED] How do I enter a SSN but only display the last four digits?
    By Caspar in forum Excel General
    Replies: 1
    Last Post: 08-04-2006, 09:00 PM
  7. Formula to extract digits from a text string?
    By [email protected] in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-15-2006, 12:16 AM

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