• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Data Extraction - Word to Excel to separate cells

    Hi all - I have a word document of addresses that I need to convert to excel and I'm running into roadblocks on how to get it done. Hoping someone here can help. The word doc is formatted like this: Dave C. Smith PhD, Consultant 804 Memorial Court TownName, WI 54001 5130 PHONE: (555)...
  2. A

    Categorization based on keywords in a string

    Luke - Glorious! Thank you for all your help. Adam
  3. A

    Categorization based on keywords in a string

    Hi Sajan - Thanks for the response! It is very much appreciated. I'm not 100% sure that gets me to where I want to be, as I need to search the string in column A for all the keywords and if it is found, then return the value in column E of whatever row the keyword was found in. If it's...
  4. A

    Categorization based on keywords in a string

    Hi Luke & Deb - First, a HUGE thanks! It put a big smile on my face on Friday night to see two intelligent responses within mere hours of posting. I feel like I'm close, but I keep getting the last result as the return instead of the result from the row. It's probably something simple...
  5. A

    Categorization based on keywords in a string

    Hi all - I could use help with the following problem. In column A, I have a string of words. (e.g. Senior Process Engineer - Plano, TX) In sheet 2, column B through column D, I have up to 3 keywords the help me categorize the string and in column E, I have the name of the category. (e.g...
Back
Top