Results 1 to 14 of 14

How to extract 4-digit long numeric value?

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2021
    Location
    Pakistan
    MS-Off Ver
    Microsoft Office LTSC Professional Plus 2021
    Posts
    17

    Question How to extract 4-digit long numeric value?

    I want to extrcat 4 digit long numeric value from thousands of cells.

    What it is: Alps, 3 to 999 worth,. 78999-../ zit,8877 99-../
    What I want: 8877 (because it is 4 digit long number)

    position of 4 digit numbers in the cells is not always same.
    Some cells have no 4 digit number I want blank output for these cells.

    please ask if you want to know something more abouth this problem, thanks.
    Attached Files Attached Files
    Last edited by Atif Bhatti; 10-07-2021 at 10:54 AM. Reason: file attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract 12 Digit Alpha Numeric
    By Barieq in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2021, 05:30 AM
  2. Replies: 5
    Last Post: 05-06-2021, 09:51 AM
  3. [SOLVED] Extract 1, 2 or 3-digit Numbers from Text String but Ignore 4-Digit Dates
    By S_Rycroft in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2020, 12:03 PM
  4. Extract first 10 digit if preceding semicolon is >10 digit
    By waffleboy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-02-2018, 05:01 AM
  5. [SOLVED] Extract each digit from 3 Digit Numbers and put in other cells?
    By Brian.Aerojet in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 05-21-2017, 08:20 PM
  6. Extract ten digit nos from numeric text
    By goodboy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2013, 08:37 AM
  7. only extract numeric value from alpha numeric cell
    By Fam via OfficeKB.com in forum Excel General
    Replies: 5
    Last Post: 04-26-2006, 01:55 PM

Tags for this Thread

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