Results 1 to 21 of 21

Extract multiple words from a cell in excel

Threaded View

  1. 10-12-2023, 09:54 AM #18
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,306

    Re: Extract multiple words from a cell in excel

    In C2:

    =TEXTBEFORE(TEXTAFTER(A2:A6,"TAV - ")," -")
    Attached Files Attached Files
    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] Search and extract multiple words from an excel cell
    By fsm458 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2022, 06:53 AM
  2. [SOLVED] Extract words from big text in excel cell
    By jesse030 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2016, 10:15 PM
  3. [SOLVED] How to extract multiple words from one cell
    By katie88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2015, 08:18 PM
  4. [SOLVED] extract a word from a cell containing multiple words and placing it in an adjacent cell
    By dopera in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-10-2013, 09:51 AM
  5. Looking for appropriate function to extract words in excel cell
    By JayshreeJK in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2012, 04:39 PM
  6. Extract or insert figures words from or to cell in excel 2007
    By Khalid Maqbool in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-30-2012, 02:08 PM
  7. [SOLVED] How to extract 3 last words from an excel cell using a predefined delimiter?
    By vaalf in forum Excel General
    Replies: 6
    Last Post: 03-27-2012, 06:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1