Results 1 to 5 of 5

How to extract words from a text string separated by comma

Threaded View

  1. 12-22-2015, 04:04 AM #1
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,999

    How to extract words from a text string separated by comma

    Hi Masters,

    I have more than 10 k text sting like "Chemistry, Hindi Rachna, Physics, Math,". I want to extract the records in other column separated by comma ",".

    Sample file is attached for your review and help pls.

    Please help me out from this thru formula only.

    Thanks/regards,
    Ankur *
    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] Dynamic COUNTIF function looking for text value in comma-separated string
    By thewhawk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-27-2017, 06:29 PM
  2. Extract Value Separated by Comma
    By bluesora in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2015, 11:15 AM
  3. [SOLVED] extract text from semicolon separated string
    By sharathnarayanan in forum Excel General
    Replies: 5
    Last Post: 08-12-2013, 08:53 AM
  4. [SOLVED] Formula to Extract Phrase in Cell to Comma Separated Text
    By ghoneim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2013, 09:44 AM
  5. Extract postcode after last comma in text string
    By TheRobsterUK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2013, 09:35 AM
  6. For Experts: How to count and cut words separated by comma into a cell?
    By lucato in forum Excel General
    Replies: 5
    Last Post: 02-05-2012, 04:44 PM
  7. [SOLVED] MSExcel--words in a cell separated by comma need to be moved into.
    By Gary in Alaska in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1