software

I have a column of text that I would like Excel to search through and return
the specific text that I am searching for. Is there a way to do this?

Thanks for any help,
--
Brian

Let's say you want to see all the rows that contain the word quot;helloquot;

Select the column and pull-down:

Filter gt; Autofilter gt; Custom... gt; Contains gt; hello
--
Gary's Studentquot;Brianquot; wrote:

gt; I have a column of text that I would like Excel to search through and return
gt; the specific text that I am searching for. Is there a way to do this?
gt;
gt; Thanks for any help,
gt; --
gt; Brian

One guess ..

Assuming source text in A1:A10 ..

With partial text to be searched entered in B1,
put this in the formula bar for C1, and array-enter
(press CTRL SHIFT ENTER):

=INDEX(A1:A10,MATCH(TRUE,(ISNUMBER(SEARCH(B1,A1:A1 0))),0))

Change SEARCH to FIND if case sensitivity is required.
(SEARCH is not case sensitive)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Brianquot; gt; wrote in message
...
gt; I have a column of text that I would like Excel to search through and
return
gt; the specific text that I am searching for. Is there a way to do this?
gt;
gt; Thanks for any help,
gt; --
gt; Brian

Is this 'filter' from the 'Data' drop-down list?
After I did 'autofilter' it simply returns to the excel sheet.

I want to do somethiong similar.
I want all the rows where the cells in column B are not a blank. Then I
want to delete those and only those rows.

Suggestions ar welcomed.--
GottaRun
------------------------------------------------------------------------
GottaRun's Profile: www.excelforum.com/member.php...oamp;userid=31297
View this thread: www.excelforum.com/showthread...hreadid=519182quot;GottaRunquot; wrote:
...
gt; I want all the rows where the cells in col B are not a blank
gt; I want to delete those and only those rows.

Tinker on a *spare* copy ..

Select col B
Click Data gt; Filter gt; Autofilter
Choose quot;(NonBlanks)quot; from the autofilter droplist in top cell
Select the filtered quot;bluequot; row headers,
right-click on these gt; Delete Row
Remove autofilter

Note: Choose quot;(blanks)quot; from the droplist if you want to delete **blank**
rows
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

Sorry I don't follow. At one point autofilter says to select 1 cell only
and not a range of cells. My comments in () below.

Thank you so much for helping.

Max Wrote:
gt; quot;GottaRunquot; wrote:
gt; ...
gt; gt; I want all the rows where the cells in col B are not a blank
gt; gt; I want to delete those and only those rows.
gt;
gt; Tinker on a *spare* copy ..
gt;
gt; Select col B (i highlighted column B)
gt; Click Data gt; Filter gt; Autofilter (check mark is on for autofilter,
gt; right?)
gt; Choose quot;(NonBlanks)quot; from the autofilter droplist in top cell (no idea
gt; what this means- do I right-click inside that cell?)
gt; Select the filtered quot;bluequot; row headers,
gt; right-click on these gt; Delete Row
gt; Remove autofilter
gt;
gt; Note: Choose quot;(blanks)quot; from the droplist if you want to delete
gt; **blank**
gt; rows ( I want to delete rows where the cell in Column B is blank, not
gt; the same as blank rows, i.e there could be non-blanks in other columns)
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; -----
GottaRun
------------------------------------------------------------------------
GottaRun's Profile: www.excelforum.com/member.php...oamp;userid=31297
View this thread: www.excelforum.com/showthread...hreadid=519182quot;GottaRunquot; wrote:
gt; Sorry I don't follow. At one point autofilter says to select 1 cell only
gt; and not a range of cells. My comments in () below.

gt; gt; gt; I want all the rows where the cells in col B are not a blank
gt; gt; gt; I want to delete those and only those rows.
gt; gt;
gt; gt; Tinker on a *spare* copy ..

If autofilter is already on, switch it off first (uncheck it)
(via Data gt; Filter gt; Autofilter)

gt; gt; Select col B (i highlighted column B)
gt; gt; Click Data gt; Filter gt; Autofilter (check mark is on for autofilter,
gt; gt; right?)
gt; gt; Choose quot;(NonBlanks)quot; from the autofilter droplist in top cell (no idea
gt; gt; what this means- do I right-click inside that cell?)

As above, try switch autofilter off first, then select col B and switch it
on
You should get an autofilter droplist (arrow) in the top cell, i.e. in B1
(Presume you have a col label in B1?)

When you click on the droplist in B1,
if col B has blank cells in between data cells
(this was presumed from your orig. post)
then the droplist in B1 will show 2 options right at the bottom
(you may need to scroll down the droplist to see), viz.:

(Blanks)
(Non Blanks)

gt; gt; Select the filtered quot;bluequot; row headers,
gt; gt; right-click on these gt; Delete Row
gt; gt; Remove autofilter
gt; gt; Note: Choose quot;(blanks)quot; from the droplist if you want to delete
gt; gt; **blank** rows

gt; I want to delete rows where the cell in Column B is blank, not
gt; the same as blank rows, i.e there could be non-blanks in other columns)

Yes, I think I read it right earlier.
The steps given above will delete *entire* rows where col B is blank

Choose quot;(Blanks)quot; from the droplist, then do the ensuing steps:

gt; gt; Select the filtered quot;bluequot; row headers,
gt; gt; right-click on these gt; Delete Row
gt; gt; Remove autofilter

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

Terrific .. got it!

Unfortunately what I took as a non-blank in cells of column B is some
icon - it displays a small magnifying glass inside the cell. What I
want to do is to delete the rows where the cells of column B has this
magnifying glass. Autofilter treted all the cells in B as blank.

This is data I 'copyamp;paste' from a website. file attached inside a
zip.

thanks again for the detailed explanation .. will come in handy. -------------------------------------------------------------------
|Filename: Book4.zip |
|Download: www.excelforum.com/attachment.php?postid=4427 |
-------------------------------------------------------------------

--
GottaRun
------------------------------------------------------------------------
GottaRun's Profile: www.excelforum.com/member.php...oamp;userid=31297
View this thread: www.excelforum.com/showthread...hreadid=519182gt; .. icon - it displays a small magnifying glass inside the cell.

These are objects/shapes, floating on top of cells, not inside.

It is possible to select all objects on the sheet via:
Press F5 gt; Special gt; Objects gt; OK
and to delete these at one go

but .. I'm not sure if there is a way (maybe via vba ?)
to also select/delete the underlying cells/rows

Hang around awhile for views from others
You may also wish to put in a new post/query in .programming
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;GottaRunquot; gt; wrote in
message ...
gt;
gt; Terrific .. got it!
gt;
gt; Unfortunately what I took as a non-blank in cells of column B is some
gt; icon - it displays a small magnifying glass inside the cell. What I
gt; want to do is to delete the rows where the cells of column B has this
gt; magnifying glass. Autofilter treted all the cells in B as blank.
gt;
gt; This is data I 'copyamp;paste' from a website. file attached inside a
gt; zip.
gt;
gt; thanks again for the detailed explanation .. will come in handy.
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Book4.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4427 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; GottaRun
gt; ------------------------------------------------------------------------
gt; GottaRun's Profile:
www.excelforum.com/member.php...oamp;userid=31297
gt; View this thread: www.excelforum.com/showthread...hreadid=519182
gt;