+ Reply to Thread
Results 1 to 10 of 10

extract numbers from a cell, before a specific text

Hybrid View

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Italy
    MS-Off Ver
    Excel 16.0
    Posts
    42

    Re: extract numbers from a cell, before a specific text

    Thank you. Moo's formula seems to work a little better, though it's not applicable when I have 99cv or lower
    For instance, sbehera's give a "#VALUE!" error when the cell contains just "170cv"

    So let's say the formula should work in the following cases:
    170cv xxxx
    170cv
    xxxx 170cv
    xxxx 170cv xxxx
    50cv xxxx
    50cv
    xxxx 50cv
    xxxx 50cv xxxx
    always extracting only the number before "cv"

    Thanks again for your kind help!
    Last edited by xlepws; 01-11-2013 at 05:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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