Results 1 to 9 of 9

Extract string from cell

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2012
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    9

    Extract string from cell

    Hello,

    I'm trying to extract the following value 'this is what I want to extract' from the below.

    m-1006621-cid:122244-kid:kwd-weweqe-KW:this is what i want to extract-e--04/08/2020 12:20:53
    m-1006621-cid:122244-kid:kwd-weweqe-KW:this is what i want to extract-b--04/08/2020 12:20:53

    I've used the following which works (using 2 formulas) but ideally want it in one:

    =IFERROR(MID(A1,FIND("KW:",A1)+3,LEN(A1)),"")
    =IFERROR(LEFT(A1,FIND("-",A1)-1),"")
    Attached Files Attached Files
    Last edited by ukguy; 08-05-2020 at 03:43 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract the value of above cell which has a particular word string
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-31-2016, 07:27 AM
  2. [SOLVED] Extract text from string in cell
    By VBA FTW in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-26-2013, 05:08 PM
  3. Replies: 3
    Last Post: 07-25-2012, 07:54 AM
  4. Extract Alphanumeric string from a cell
    By kenny.fsw in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 04:36 AM
  5. Extract string from a cell
    By scottt725 in forum Excel General
    Replies: 3
    Last Post: 04-10-2012, 10:37 PM
  6. Extract number from cell as string
    By Tey in forum Excel General
    Replies: 4
    Last Post: 04-22-2010, 03:30 AM
  7. Extract string from cell
    By greavesy in forum Excel General
    Replies: 14
    Last Post: 08-20-2009, 10:03 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