| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If command
Is it possible to write something liket this IF (cell2.Value = ".com"....)I'm
trying to do a search through a couple of spreadsheets where I would search for www.abc.com or www.abc.net so the search would have to First search for a com then a .net can I do that? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200704/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If command
Try something like IF RIGHT(cell2.Value,4) = ".com"
hth |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If command
That will work for .com and .net?
Keith74 wrote: Try something like IF RIGHT(cell2.Value,4) = ".com" hth -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One command in one cell initiating another command in another cel. | Excel Worksheet Functions | |||
| command code ( GOTO command) in formula | New Users to Excel | |||
| Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
| Print an excel file from command line or "cron" type command ??? | Excel Programming | |||
| Excel to load COMMAND and type a Run Command? | Excel Programming | |||
Linear Mode
