+ Reply to Thread
Results 1 to 6 of 6

Extract Numbers From Cell

  1. 03-07-2022, 05:21 PM #1
    Young Novice
    Young Novice is offline
    Registered User
    Join Date
    03-03-2022
    Location
    Salt Lake City, UT
    MS-Off Ver
    22
    Posts
    5

    Extract Numbers From Cell

    Ok so I have a program on AutoCAD that allows me to generate lengths that I configure into an excel sheet. Attached is a sample of what populates. Essentially, I want to find a way to extract the lengths of the conveyors and populate them as one rounded length in the adjacent column. For example, if a length is 5 ft., 6 in. I want the adjacent cell to gather that info and produce the number 6 (so every length always rounds up even if it is only 1 in. longer than the nearest foot). I have been messing with different commands but cannot figure it out for the life of me. Please help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-07-2022, 05:28 PM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,739

    Re: Extract Numbers From Cell

    i have done this a different way
    =IF(RIGHT(B2,3)="in.",LEFT(B2,FIND("ft",B2)-2)*1+1,LEFT(B2,FIND("ft",B2)-2)*1)

    if there are inches "in." - then round up +1
    if not , then leave alone

    does that work ?
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 03-07-2022, 05:31 PM #3
    Young Novice
    Young Novice is offline
    Registered User
    Join Date
    03-03-2022
    Location
    Salt Lake City, UT
    MS-Off Ver
    22
    Posts
    5

    Re: Extract Numbers From Cell

    Yes that works great for me! Now I just need to figure out how to leave an empty cell if no length populates. Conveyors that are curves do not produce a length. In those instances "#VALUE!" populates.
    Reply With QuoteRegister To Reply
  4. 03-07-2022, 05:33 PM #4
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,739

    Re: Extract Numbers From Cell

    =IFERROR(IF(RIGHT(B2,3)="in.",LEFT(B2,FIND("ft",B2)-2)*1+1,LEFT(B2,FIND("ft",B2)-2)*1),"")
    Reply With QuoteRegister To Reply
  5. 03-08-2022, 08:57 AM #5
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,292

    Re: Extract Numbers From Cell

    Ctrl+h and formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 03-08-2022, 11:09 AM #6
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,292

    Re: Extract Numbers From Cell

    PQ
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Extract Numbers from a cell
    By kunjgemi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-22-2019, 09:27 AM
  2. [SOLVED] How to Display Numbers Only OR How To Extract Numbers In A Cell
    By PaddyP in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-17-2016, 12:32 PM
  3. Extract the first numbers from a cell
    By neverloggedin in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-04-2013, 06:57 AM
  4. Extract numbers from cell
    By kingsgambit107 in forum Excel General
    Replies: 5
    Last Post: 07-17-2011, 01:28 PM
  5. Extract numbers from cell with Text and Numbers
    By wiredwrx in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-18-2006, 06:00 PM
  6. [SOLVED] How do I extract numbers from a cell with both text and numbers?
    By SHANNON in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-01-2005, 10:35 PM
  7. [SOLVED] extract numbers from cell containing text & numbers
    By [email protected] in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2005, 03:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1