@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...
@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...
@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...
@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...
@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...
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...
@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...
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)...
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...