+ Reply to Thread
Results 1 to 4 of 4

Extract texts from a cell and paste it to another cell

  1. #1
    Registered User
    Join Date
    11-22-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    Extract texts from a cell and paste it to another cell

    I have an excel file that contains descriptions of varying length.
    What i need is to extract the words (Black, Yellow, Chocolate, Silver, Fox Red, Cream, White) and have it placed on a different cell. Then another set (English, Show, Bench, Field, American) also to be inserted to another cell.
    Is this possible? Thanks for your help.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Extract texts from a cell and paste it to another cell

    Please attach a sample data with expected output for providing solution.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    11-22-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Extract texts from a cell and paste it to another cell

    Thanks for the reply. I have attached the sample data for your reference.
    Basically the two columns where i would like to put the results will be on Color and Type.
    Attached Files Attached Files

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Extract texts from a cell and paste it to another cell

    Thanks for the attachment and just providing 1 expected output will not help us in understanding the logic. If you provided the expected output for at least 10 rows then it will helpful. At the same time please share your idea based on which logic the formula should be applied for getting the result.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1