wild card

I have a huge spreadsheet of contact. I am trying to scrub out all the email address that contain an email extensions on my exclusion list. For example @gmail.com and I am trying to use a wildcard character to find all the email address within my table that cannot be contacted. I am unable to...

Hi all, Since it is my first time using Excel in this manner, I am not sure if Excel is even able to do so, but I have to try because if it works, it will save me a lot of time. I have got three columns (of which one in a different workbook, but I assume that will not be a problem) Column A: a...

I'm using the formula below to populate a cell if another cell does not contain any of the following "R", "0" or is Blank. if the cell "sheet2!G11" has any of those in it the formula cell is left Blank. If the cell contains anything else then it populates with what is in cell "sheet2!D11"...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif][if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/>...

Hello! I am trying to write a function that will keep the text matching a search with wild cards. The text in a given cell is structured as follows: Cell A1: 0001: greenlight go, 0002: red car, 0003: monsterblue Cell A2: 0006: pink thing, 0076: applered I now want to search for the word red...

Hi, I need to process a column of fleet numbers. If the number starts with CH I need to copy it to one file, if it starts with F copy to another if neither I have to ignore it. Can Excel 2003 handle wild card searching ? Eg. : Case CH* ... Case F* .... Case else .. nothing Regards...

I am a VBA novice and I would greatly appreciate some help please as this is driving me mad<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have a macro (below FIRSTSUB) which works okay. What it does is identify if a cell in Col 1 contains...

Hi there, I am a VBA novice and I would greatly appreciate some help. I am using Countif in a relatively simple macro to identify if a cell contains a particular string. The idea is to delete the row if the string is present. So for example the two lines of code would read: If...

Hi, I'm trying to delete sheets that have specific names or similar (e.g. delete "Sheet1" and "Sheet1 (2)") I am using the following code: For Each ws In Worksheets Select Case ws.Name Case "Remaining*", _ "No_Break*", _ "Listed_Instruments*", _...