 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Find 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? > Hello, > [quoted text clipped - 3 lines] > > 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 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... > > Hello, > > [quoted text clipped - 8 lines] > > gls858 > Hi, > [quoted text clipped - 15 lines] >> >> gls858 I that case auto filter will not work. Take a look at Don's suggestion. gls858 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 > Hi, > [quoted text clipped - 18 lines] >> >> gls858 Look in vba help index for FINDNEXT  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hello, > [quoted text clipped - 4 lines] > > Any suggestions? OK - really silly question: How do I access VBA Help? > Look in vba help index for FINDNEXT > [quoted text clipped - 6 lines] > > > > Any suggestions? alt f11 is one way SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > OK - really silly question: How do I access VBA Help? > [quoted text clipped - 8 lines] >> > >> > Any suggestions? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.