Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Logical functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - IsLike function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Logical - IsLike

Syntax:
=IsLike(Text, Pattern)

Description:
Returns TRUE when the Text compares to the pattern. Equivalent to the Visual Basic Like function.

Example:

Does the string hello word start with the word hello.
=IsLike("hello world","hello*")
Does the string hello word start with the word h?llo where ? can be any character.
=IsLike("hello world","h?llo*")


litLIB