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

    Find text separated by line breaks on a cell-by-cell basis

    @jindon Thanks for the suggestion but, in the meantime, I've discovered the CLEAN function (remember I'm a newbie) which enables me to search my data very effectively. First I copy my data cells to a separate worksheet, then render each cell "clean" using the CLEAN function, then do a "special...
  2. T

    Find text separated by line breaks on a cell-by-cell basis

    @vletm Thanks again. I'll have a play with your file using my "data". TonyC ▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
  3. T

    Find text separated by line breaks on a cell-by-cell basis

    @vletm Thanks for getting back to me. You asked: how do You want to see results? ... and do You want to 'update' Your original data? Basically all I need to know is which "data" cells (all in column A) contain the data being searched. So for example if cell A500 returns a hit, then it would...
  4. T

    Find text separated by line breaks on a cell-by-cell basis

    @vletm - exactly right. I've been using Excel for my choreo stuff for about 10 years and it's great for my particular needs even though the "data" may look funny to most people. Thanks for your interest and efforts (likewise to @Marc L). If you can suggest any other sites worth trying, I'd...
  5. T

    Find text separated by line breaks on a cell-by-cell basis

    @vletm I attach the file I previously uploaded with the two sets of vertically aligned strings 3G> and 1B< highlighted in red and underlined (in A2 under item 14). I'm looking for some code which will find cells in which the two strings appear in that way - i.e. one above the other, vertically...
  6. T

    Find text separated by line breaks on a cell-by-cell basis

    @MarcL, @vletm Thanks for persisting with this! I really appreciate your patience. The example I gave above was to find the following: 3G> 1B< in the Sample file. If you go to the A2 cell, you'll find the example search query immediately following the line referenced 14 towards the bottom...
  7. T

    Find text separated by line breaks on a cell-by-cell basis

    Thanks vletm and MarcL for your efforts but it's not what I'm looking for. I don't really want to know if certain strings are both present somewhere in the same cell, I want to know if those strings are juxtaposed in the sense of being separated from each other by a blank line. Going back to my...
  8. T

    Find text separated by line breaks on a cell-by-cell basis

    @vletman - sorry I thought my issue was pretty straightforward but perhaps not so I'm uploading a file containing some typical content - see cells A1 and A2. Imagine that the worksheet actually contains thousands of cells in column A and suppose, for the sake of example, I want to find those...
  9. T

    Find text separated by line breaks on a cell-by-cell basis

    Thanks Logit. Looks to me like your suggestion will find line breaks but I'm looking for instances of the specific entry: "aaa"; blank line; "bbb" where aaa and bbb are variable from one search to another. So for instance, one search might involve looking for cells containing: 2B> (blank line)...
  10. T

    Find text separated by line breaks on a cell-by-cell basis

    Hi - a newbie here. Is it possible in Excel to find text separated by line breaks within a cell? Suppose the text consists of the following in the same cell: “aaa” on one line; a blank line; and then on the next line “bbb”. How can I find all instances of this combination in a Worksheet...
Back
Top