wild card

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*", _...