Results 1 to 5 of 5

extract text between 2 different characters

Threaded View

Grahamfeeley extract text between 2... 01-31-2021, 04:59 AM
Bo_Ry Re: extract text between 2... 01-31-2021, 05:19 AM
jindon Re: extract text between 2... 01-31-2021, 05:20 AM
Grahamfeeley Re: extract text between 2... 01-31-2021, 10:29 AM
karedog Re: extract text between 2... 01-31-2021, 05:24 AM
  1. #1
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    extract text between 2 different characters

    Hi I cant seem to get this formula right, being trying hard enough....

    in column A starting A2 i have a lot of rows of data such as this in the attachment

    I wish to extract 4 columns data starting in B2 which I have solvedthe first column in B2
    But I am stuck with rest of extraction which involves the Mid function
    as I said I got B2 solved

    I managed to extract the first extraction which has column header Horse
    But I cant solve the rest of the formulas for racno, Track and tabno
    Any help will be greatly welcome
    Graham
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract a text between 2 characters
    By ionelz in forum Excel General
    Replies: 5
    Last Post: 01-20-2020, 07:35 AM
  2. [SOLVED] Extract text between two characters
    By bhenlee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2018, 10:22 AM
  3. Extract text between certain characters
    By spiphix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-08-2016, 05:19 PM
  4. [SOLVED] Extract certain text dependant on number of characters in text
    By bjoanmark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2014, 02:57 AM
  5. Extract text between two characters in a string - varing text length
    By luv2birdie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2014, 06:10 PM
  6. [SOLVED] Extract 50 characters text to a new worksheet
    By skyflare in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2013, 01:44 AM
  7. extract text separated by characters
    By RANDYC1152 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2009, 09:54 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