+ Reply to Thread
Results 1 to 6 of 6

Extract Words

  1. 05-10-2017, 01:09 PM #1
    nits1982
    nits1982 is offline
    Registered User
    Join Date
    11-25-2011
    Location
    pune, india
    MS-Off Ver
    Excel 2003
    Posts
    21

    Extract Words

    Hi

    Please help me to extract nth word in excel like last word/second last/third last
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-10-2017, 01:33 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Extract Words

    Hi,

    This data seems to have come from a comma separated file. Are you sure that a simple Text To Columns using the comma as a delimiter won't give you what you want?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 05-10-2017, 01:38 PM #3
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Extract Words

    Enter formula in B1 and copy across and down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    1
    		 Plot No: A-18, MIDC,,Chakan, Village Mahalunge, Pune –,,Pune,MAHARASHTRA,India,410501 410501 India MAHARASHTRA
    2
    		 44/220 KV, Purnea Substation,Moranga Road NH-31 by pass, Purnia,,Purnia,BIHAR,India,854102 854102 India BIHAR
    3
    		 VILLAGE KULPATIPUR,POST BHARAT GANJ,,Allahabad,UTTAR PRADESH,India,211003 India PRADESH UTTAR
    4
    		 Goa Medical College, Bamolim,,,North Goa,GOA,India,403202 403202 India GOA
    Sheet: Sheet1
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  4. 05-10-2017, 01:39 PM #4
    nits1982
    nits1982 is offline
    Registered User
    Join Date
    11-25-2011
    Location
    pune, india
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Extract Words

    No comma separated but number of words diffrent in each coloumn
    Reply With QuoteRegister To Reply
  5. 05-10-2017, 01:40 PM #5
    nits1982
    nits1982 is offline
    Registered User
    Join Date
    11-25-2011
    Location
    pune, india
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Extract Words

    Thanks for the quick help
    Reply With QuoteRegister To Reply
  6. 05-10-2017, 01:55 PM #6
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Extract Words

    I think this one would give a more accurate results
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    1
    		 Plot No: A-18, MIDC,,Chakan, Village Mahalunge, Pune –,,Pune,MAHARASHTRA,India,410501 410501 India MAHARASHTRA
    2
    		 44/220 KV, Purnea Substation,Moranga Road NH-31 by pass, Purnia,,Purnia,BIHAR,India,854102 854102 India BIHAR
    3
    		 VILLAGE KULPATIPUR,POST BHARAT GANJ,,Allahabad,UTTAR PRADESH,India,211003 211003 India UTTAR PRADESH
    4
    		 Goa Medical College, Bamolim,,,North Goa,GOA,India,403202 403202 India GOA
    Sheet: Sheet1
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] EXtract First Two Words
    By Deventus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2014, 11:50 AM
  2. Need to extract last 4 words from a cell
    By DrFistington in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2014, 05:12 PM
  3. [SOLVED] extract last 2 words of cell
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-26-2014, 04:09 PM
  4. [SOLVED] Need to extract words or text from a cell containing numeric / alpha-numeric and words
    By vatsan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-25-2014, 02:00 AM
  5. [SOLVED] extract the first two words (or take out the last word)
    By rickytj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2013, 11:58 PM
  6. [SOLVED] looking formula for Extract Specific WORDs in existing LONG Words
    By santosh226001 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2013, 08:21 AM
  7. Extract all but last two words
    By rwl518p in forum Excel General
    Replies: 2
    Last Post: 12-12-2011, 10:06 AM

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