+ Reply to Thread
Results 1 to 6 of 6

How to pull a word or words from a cell and place in same row different cell

  1. #1
    Registered User
    Join Date
    02-02-2015
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    2

    How to pull a word or words from a cell and place in same row different cell

    Hello,

    I have about 35K rows I need to pull some information out of a cell and copy it into another cell on the same sheet and same row, just into a different column.

    Here are some samples of what I am working with:

    20266 11.5M W/P BLACK LEDGE
    13858 13EE 4.5" VICIOUS W/P BROWN/ORANGE

    What I need to do for the first sample is pull out the word Black and have it placed in another Cell on the second example I need the BROWN/ORANGE on the same row but different column(would prefer to use the same column for all information pulled.(the key is everything must stay in the same row).
    This project is NOT case sensitive.

    Thank you for any and all help.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to pull a word or words from a cell and place in same row different cell

    You get better help on your question if you add an excel file, without confidential information.

    Please also add the desired (expected) result.

    The color is always after the text W/P?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: How to pull a word or words from a cell and place in same row different cell

    Is the "break" always on W/P?

    Try this...
    =MID(A2,SEARCH("W/P",A2,1)+4,99)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    02-02-2015
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    2

    Re: How to pull a word or words from a cell and place in same row different cell

    Sample.csv

    Hopefully that attachemnet worked OK, You will see say the first 10 rows of data have the color pulled out manually, I am looking for a way to have excel do this for me, there is no rhyme or reason to the way the data was originally put in so I am looking at all options at this time.

    Thank You,

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to pull a word or words from a cell and place in same row different cell

    Please answer the questions the forummembers ask you.

    Are all colors know (so there is a change we can search for the color)?

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: How to pull a word or words from a cell and place in same row different cell

    Did you try my suggestion? It looks like it will get you a long way towards where you want to be. I can probably tweak it a bit, but will need info on how it is working for you

+ 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] Excel Formula to pull data from another sheet and place cell blank if value is 0
    By szpt9m in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 09-18-2013, 01:07 AM
  2. [SOLVED] Need a Macro to pull data from one cell and place into another one time
    By jgregory43 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-05-2013, 03:26 PM
  3. Replies: 5
    Last Post: 01-10-2013, 09:51 AM
  4. Replies: 4
    Last Post: 05-31-2012, 04:56 PM
  5. Search word and Place founded word in cell
    By 9813268329 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-01-2010, 07:27 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1