Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
character limitations
if the active cell has the first 7 characters = "example", I want it to return a value in another cell. ie,
"example 7", "example fourty nine" and "example spiderman" would all return a value, where as... "7", "fourty nine" and "spiderman" would not. TIA Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
character limitations
myVal = 50
if lcase(Left(ActiveCell.Value,7)) = "example" then ActiveCell.Offset(0,1).Value = myVal End if -- Regards, Tom Ogilvy "Chris" wrote in message ... if the active cell has the first 7 characters = "example", I want it to return a value in another cell. ie, "example 7", "example fourty nine" and "example spiderman" would all return a value, where as... "7", "fourty nine" and "spiderman" would not. TIA Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel character limitations | Excel Discussion (Misc queries) | |||
vlookup character limitations | Excel Worksheet Functions | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Character limitations for excel fields | Excel Worksheet Functions | |||
Character limitations | Excel Discussion (Misc queries) |