+ Reply to Thread
Results 1 to 5 of 5

Extract words from cells into a new cell

  1. #1
    Registered User
    Join Date
    08-11-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    93

    Extract words from cells into a new cell

    Dear forum,

    I have cells that includes text, numbers etc and I need to extract the text into a new cell (kind of cleanup)

    It looks like this:

    1: Light Yellow: 1,00, 8: Dark Green: 1,00, 12: Light Blue: 2,00

    item number: item name: amount with decimal,

    What I need is to extract the item name with a " + " as a separator if there is more items in the cell.
    So for this example it would be:
    Light Yellow + Dark Green + Light Blue

    Sample file attached

    Thanks
    Attached Files Attached Files
    Last edited by soli004; 07-17-2014 at 04:23 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Extract words from cells into a new cell

    Try the following macro:
    Please Login or Register  to view this content.
    HTH!

  3. #3
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: Extract words from cells into a new cell

    And here is my trial :P

    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Extract words from cells into a new cell

    Please Login or Register  to view this content.

  5. #5
    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 from cells into a new cell

    And just in case, a formula solution


    Formula: copy to clipboard
    Please Login or Register  to view this content.


    A
    B
    1
    Before Result
    2
    1: Light Yellow: 1,00, 8: Dark Green: 2.00, 13: Blue: 1,00 Light Yellow + Dark Green + Blue
    3
    4: Orange: 1,00 Orange
    4
    4: Orange: 1,00, 6: Light Grey: 1,00, 8: Dark Green: 1,00 Orange + Light Grey + Dark Green
    5
    6: Light Grey: 2,00, 8: Dark Green: 1,00, 13: Blue: 2,00 Light Grey + Dark Green + Blue
    6
    2: Black: 1,00, 4: Orange: 2,00, 6: Light Grey: 1,00 Black + Orange + Light Grey
    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 to 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 last 2 words of cell
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-26-2014, 04:09 PM
  2. Replies: 7
    Last Post: 02-25-2014, 02:00 AM
  3. Extract words from cells containing text
    By Pelona in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-02-2013, 05:17 PM
  4. Extract particular words from a cell
    By DeepakS in forum Excel General
    Replies: 2
    Last Post: 08-22-2011, 08:58 AM
  5. [SOLVED] Extract specific words from cells
    By Santa-D in forum Excel General
    Replies: 6
    Last Post: 06-18-2006, 11:10 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