| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find text and copy elsewhere
Hello,
I would like to find all instances of a specific word in a column of approx. 1200 rows and copy them in either another row/sheet. I tried the autofilter but it didn't seem to work. Any suggestions? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find text and copy elsewhere
QPapillon wrote:
Hello, I would like to find all instances of a specific word in a column of approx. 1200 rows and copy them in either another row/sheet. I tried the autofilter but it didn't seem to work. Any suggestions? What do you mean didn't work? What were the result? Is the word a single word in the cell or is it included in a string of text? gls858 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find text and copy elsewhere
Hi,
It's a single word in a string of text, i.e. I want to search for all instances of the word "upgrade" in a bunch of comments. I tried auto-filter and it picked the first sentence with the word in it and then it showed a whole bunch of other ones that didn't have the word... "gls858" wrote: QPapillon wrote: Hello, I would like to find all instances of a specific word in a column of approx. 1200 rows and copy them in either another row/sheet. I tried the autofilter but it didn't seem to work. Any suggestions? What do you mean didn't work? What were the result? Is the word a single word in the cell or is it included in a string of text? gls858 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find text and copy elsewhere
QPapillon wrote:
Hi, It's a single word in a string of text, i.e. I want to search for all instances of the word "upgrade" in a bunch of comments. I tried auto-filter and it picked the first sentence with the word in it and then it showed a whole bunch of other ones that didn't have the word... "gls858" wrote: QPapillon wrote: Hello, I would like to find all instances of a specific word in a column of approx. 1200 rows and copy them in either another row/sheet. I tried the autofilter but it didn't seem to work. Any suggestions? What do you mean didn't work? What were the result? Is the word a single word in the cell or is it included in a string of text? gls858 I that case auto filter will not work. Take a look at Don's suggestion. gls858 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find text and copy elsewhere
How did you use Autofilter?
Click the Autofilter down-arrow select 'Custom' (third item down), On the left, change 'Equals' to 'Contains'. On the right, type "upgrade", click OK Does this work? George Gee "QPapillon" wrote in message ... Hi, It's a single word in a string of text, i.e. I want to search for all instances of the word "upgrade" in a bunch of comments. I tried auto-filter and it picked the first sentence with the word in it and then it showed a whole bunch of other ones that didn't have the word... "gls858" wrote: QPapillon wrote: Hello, I would like to find all instances of a specific word in a column of approx. 1200 rows and copy them in either another row/sheet. I tried the autofilter but it didn't seem to work. Any suggestions? What do you mean didn't work? What were the result? Is the word a single word in the cell or is it included in a string of text? gls858 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find text and copy elsewhere
Look in vba help index for FINDNEXT
-- Don Guillett Microsoft MVP Excel SalesAid Software "QPapillon" wrote in message ... Hello, I would like to find all instances of a specific word in a column of approx. 1200 rows and copy them in either another row/sheet. I tried the autofilter but it didn't seem to work. Any suggestions? |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find text and copy elsewhere
OK - really silly question: How do I access VBA Help?
"Don Guillett" wrote: Look in vba help index for FINDNEXT -- Don Guillett Microsoft MVP Excel SalesAid Software "QPapillon" wrote in message ... Hello, I would like to find all instances of a specific word in a column of approx. 1200 rows and copy them in either another row/sheet. I tried the autofilter but it didn't seem to work. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND LAST COPY OF A TEXT IN A COLUMN | Excel Discussion (Misc queries) | |||
| Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
| Find text and copy and move row containing it | Excel Discussion (Misc queries) | |||
| Excel find text and copy rows | Excel Discussion (Misc queries) | |||
| Find text in cell, copy row to new sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
