Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / January 2008

Tip: Looking for answers? Try searching our database.

Wildcard Searches across Worksheets

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
avilliers@gmail.com - 25 Jan 2008 22:15 GMT
I need to be able to find the following patterns within my data -
usually within an entire workbook or worksheet:

Annnn (or B3425 as an example)
A = any letter A-Z
n = any number 0-9

This pattern would normally be found repeated in one column of any
worksheet but sometime they get scattered around thus the need to
search the whole workbook/sheet.

Using Excel 2003 here.

Is anyone familiar with using functions to code this or possibly an
add-in? Thanks.

-Alan-
Matt Richardson - 25 Jan 2008 23:34 GMT
On Jan 25, 10:15 pm, avilli...@gmail.com wrote:
> I need to be able to find the following patterns within my data -
> usually within an entire workbook or worksheet:
[quoted text clipped - 13 lines]
>
> -Alan-

Hi.

Can I ask what exactly you want the code to do?  Do you want it to
highlight the cells in question, or do you want them copying and
pasting to another sheet?

Regards,
Matt Richardson
http://teachr.blogspot.com
 
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.