+ Reply to Thread
Results 1 to 4 of 4

Extract Data

  1. #1
    Registered User
    Join Date
    06-26-2021
    Location
    USA
    MS-Off Ver
    2019
    Posts
    8

    Extract Data

    Hello all,

    Would anyone be able to help? Using example data below and the length will be different for each row.

    in cell A1 data:
    John Doe XXX X-1 Do Not Know XXX-Xvnbnn abbn-mnmmm-22288

    in B1>> I would like the formula to look for 2 hyphens from right and return that set of data. Below is the formula I use, it gives some, but not working well.
    =RIGHT(B2, SEARCH("-", B2)-5)

    The result in B1 would be: abbn-mnmmm-22288

    Thank you kindly for helping!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: Extract Data

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-26-2021
    Location
    USA
    MS-Off Ver
    2019
    Posts
    8

    Re: Extract Data

    TMS, Thank you so much! This works great! Thanks!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: Extract Data

    You're welcome. Thanks for the rep.

+ 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. VBA to extract zip file attachments AND extract time stamp data from .msg file
    By natjo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2020, 06:59 PM
  2. [SOLVED] Extract/Generate Data through VBA based on period basis from master data sheet
    By Pankaj jaswani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2020, 07:58 AM
  3. [SOLVED] vba code to extract data from data table and update data sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-25-2017, 01:23 PM
  4. [SOLVED] Extract Data /Look up Data / To get data automatically by refering invoice number
    By PMH2384 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-17-2017, 04:03 AM
  5. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  6. Extract all data to new workbook then filter and extract to new worksheets
    By graphicgoose in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2014, 08:18 PM
  7. Replies: 11
    Last Post: 12-04-2012, 02:56 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1