Results 1 to 4 of 4

Extract Number with Values/Text ONLY if number in front and Values/Text ONLY if no number

Threaded View

  1. 01-13-2021, 12:31 AM #1
    bjnockle
    bjnockle is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,012

    Extract Number with Values/Text ONLY if number in front and Values/Text ONLY if no number

    Looking for formula to extract number with values/text ONLY if there is number in front of the values and extract Values/Text ONLY if there is no number in front of the values/text from column I. Desired outcome is in column J. See attached sample.

    Thanks
    Attached Files Attached Files
    Last edited by bjnockle; 01-13-2021 at 12:38 AM.
    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] Countif for specific number before (or front) or after (or last) number or text present
    By Sekars in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-25-2019, 03:48 AM
  2. [SOLVED] Geting highest number value from list with values which are text/number combinations
    By igormigor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2016, 10:48 AM
  3. extract number from text and number cell
    By south in forum Excel General
    Replies: 15
    Last Post: 08-23-2014, 03:28 AM
  4. insert text in front of Text OR number - user defined format
    By Simon-ch in forum Excel General
    Replies: 12
    Last Post: 10-03-2008, 09:02 AM
  5. Extract number from text/number string..
    By nastech in forum Excel General
    Replies: 5
    Last Post: 07-05-2006, 06:25 PM
  6. Extract phone number front block of text
    By Tech in forum Excel General
    Replies: 6
    Last Post: 08-08-2005, 12:05 PM
  7. Search for text, copy the number in front of text
    By w0cyru01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2005, 12:15 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