+ Reply to Thread
Results 1 to 2 of 2

Need to extract specific but varying length and location numbers from description

  1. #1
    Registered User
    Join Date
    06-07-2016
    Location
    MI, USA
    MS-Off Ver
    2007
    Posts
    8

    Need to extract specific but varying length and location numbers from description

    I need to find a way to retrieve, isolate, and/or extract specific numbers that are before specific words. The numbers that I need are buried in a sometimes quite lengthy description that contains both text and numbers. I need a way to just get the numbers before the words acres, A, or AC as all three are used in the descriptions which vary quite a bit. If there is a macro, add in, software, or formula that can achieve this it would save me days of work and grant you my eternal gratitude. As an example of what I would like done I can only give a vague template of how the descriptions look as they are all unique. Also, I can not give an actual copy of the worksheet I need the fix for as it holds private and proprietary information so I will have to give a similar looking template example.

    AA-31 3/0 GL1 SEC 31 T56N R50W PART OF S ½ OF NE ¼ AND GL6; TH N8931'40''W 2382.34' TO THE NS ¼ LN TH S0058'02''W 2596.66' TO THE SW COR OF GL1 TH S8928'14''E 1845.80' ALG TH S LINE OF GL1 TH N4521'27''E 776.25' TH N0014'38''E 6088.75' TO THE POB. PARCEL CONTAINING 133.89 AC M/L SPLIT ON 09/27/2009 FROM 901-181-088-08; 002-131-009-00

    From this I need to get 133.89 Or 133.89 AC. Other cells have the number I want listed before the word ACRES or before just A so if there is a way that I can customize the unit after the numbers I want that would be extremely helpful as well.

    If there is any possible way to do something like this in excel then it would make my life exponentially easier. Thank you for your time and consideration on this matter in advance.

  2. #2
    Registered User
    Join Date
    06-07-2016
    Location
    MI, USA
    MS-Off Ver
    2007
    Posts
    8

    Re: Need to extract specific but varying length and location numbers from description

    Also if it helps I already have ASAP utilities installed so if there is a way to use any of the tools in that to do this then that will work as well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to extract text from cells of varying length?
    By dukefan4141 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-12-2015, 10:42 PM
  2. [SOLVED] Extract text from end of string with varying length
    By reedersketer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2015, 05:16 PM
  3. Replies: 12
    Last Post: 11-05-2012, 12:35 PM
  4. [SOLVED] Pulling specific TEXT out of a string of varying length
    By Lasloja in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2012, 05:26 PM
  5. Replies: 5
    Last Post: 09-11-2012, 08:40 AM
  6. Extracting numbers of varying length from a string
    By bethj in forum Excel General
    Replies: 3
    Last Post: 12-13-2011, 06:03 AM
  7. Replies: 6
    Last Post: 10-01-2009, 02: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1