• 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. R

    Search within a string for multiple values and output in a different cell

    Oh about 20 or so... nearly done with the random exceptions!
  2. R

    Search within a string for multiple values and output in a different cell

    Ahah! Thanks Faseeh, that looks like one of those famous arrays that I have been hearing about? On my own I got this working, but then hit the maximum number of If statements allowed in 2010. I suppose with your method there is no maximum? =IF(ISERROR(SEARCH("water", [@[Description 1 most...
  3. R

    Search within a string for multiple values and output in a different cell

    Dear all, I have a database of 1500 records and I need to put descriptions from one cell into categories in another. I dont want to do this manually! The cells with the header 'description' contain contents like: -Problem with inputs -would like access to credit -Need help with marketing...
Back
Top