+ Reply to Thread
Results 1 to 4 of 4

How can I use excel to make this task more manageable?

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Beirut
    MS-Off Ver
    Excel OSX
    Posts
    38

    Question How can I use excel to make this task more manageable?

    So I have a list of over 2,000 rows each which contains one cell per row with a description that includes a products model. Each description is different, although many are alike. For example, row 1 would read: "blablabla of type model X blablabla" while row 2 will have: "blablabla type Y" (where Y is the model type but not use of the word "model" is made); and row 3: "blablabla model O blabla".

    I need to remove all model information from each of the descriptions (i.e. cells in each rows) and have no idea how to make this task more manageable. I was thinking of separating each cell into different cells, so one cell per word, to help identify and remove/re-edit any model information. Then I would re-join all the cells via a concatenate type function.

    Any ideas?

  2. #2
    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,939

    Re: How can I use excel to make this task more manageable?

    I think you are going to need to be a bit more specific than just "blablabla"

    Is this always just 1 word?
    is it numbers

    upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    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

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    Beirut
    MS-Off Ver
    Excel OSX
    Posts
    38

    Re: How can I use excel to make this task more manageable?

    Sorry for the confusion. So to clarify each cell contains a sentence, and I want to eliminate ONE word (i.e. model information) in each of these sentences. The sentence may contain 15 words, one of them being the model; or just 10 words, with, once again, only one of them being the model. To make things more complicated, the model may also be two word.

    I'm not sure how to go about this, but thought that posting here may give me a good idea on what approaches to start considering. Thanks!

  4. #4
    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,939

    Re: How can I use excel to make this task more manageable?

    upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

+ 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. export excel list of task in custom outlook task 2010.
    By maxseal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2014, 03:51 PM
  2. Replies: 1
    Last Post: 02-13-2014, 08:26 AM
  3. Try to make a macro to do repeated task
    By JeffGajes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2012, 12:24 PM
  4. Creating manageable List in Excel Form
    By jvechey in forum Excel General
    Replies: 3
    Last Post: 01-14-2010, 12:20 PM
  5. Make paragraphs in body of outlook task created from Excel
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2008, 06:54 AM

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