Results 1 to 17 of 17

Extract number from string and add zero

Threaded View

Jacc Extract number from string... 09-16-2017, 03:36 PM
sandy666 Re: Extract number from... 09-16-2017, 03:48 PM
Root_ Re: Extract number from... 09-16-2017, 03:54 PM
Jacc Re: Extract number from... 09-16-2017, 04:07 PM
Root_ Re: Extract number from... 09-16-2017, 04:18 PM
Jacc Re: Extract number from... 09-16-2017, 03:59 PM
sandy666 Re: Extract number from... 09-16-2017, 04:06 PM
Jacc Re: Extract number from... 09-16-2017, 04:34 PM
sandy666 Re: Extract number from... 09-16-2017, 04:40 PM
jeffreybrown Re: Extract number from... 09-16-2017, 04:48 PM
Jacc Re: Extract number from... 09-16-2017, 04:51 PM
sandy666 Re: Extract number from... 09-16-2017, 04:58 PM
Jacc Re: Extract number from... 09-16-2017, 06:02 PM
sandy666 Re: Extract number from... 09-16-2017, 06:23 PM
Jacc Re: Extract number from... 09-17-2017, 04:10 AM
sandy666 Re: Extract number from... 09-17-2017, 05:48 AM
Jacc Re: Extract number from... 09-17-2017, 07:26 AM
  1. 09-16-2017, 04:06 PM #7
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Extract number from string and add zero

    Col A is source for PQ.

    see att. without BASE() function

    I added in row 16 new value then refresh PQ table. Try by yourself
    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] Vba to extract number from string
    By Sintek in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-28-2017, 12:24 PM
  2. [SOLVED] How to Extract A Number from String if Text within the String Equals XYZ
    By tyrsfury in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-15-2012, 03:30 PM
  3. [SOLVED] Extract a mainly numeric string (ISSN number) from an arbitrary string
    By Buzzed Aldrin in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-04-2012, 01:49 PM
  4. Extract Number from String Help
    By kobe4ever8 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2011, 02:25 PM
  5. Extract number out of a string
    By mkvassh in forum Excel General
    Replies: 4
    Last Post: 04-07-2010, 05:25 PM
  6. Extract Only Number From A String
    By lehainam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2006, 06:45 AM
  7. How to extract the Number from a String
    By johnbest in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-19-2005, 02:30 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