MS Excel - Formula To Find If A String Contains ...

Tips and tricks using VBA and office automation ...
User avatar
magicrat
Site Admin
Posts: 13
Joined: Sun Dec 14, 2014 12:33 pm
Location: Manassas, VA
Contact:

MS Excel - Formula To Find If A String Contains ...

Postby magicrat » Sat Nov 14, 2015 12:28 pm

Yields a boolean result ...

Example below searches for the character "@" in cell D2 ... and returns "Yes" if found.

=IF(ISNUMBER(SEARCH("@",D2)), "Yes", "No")
-- Rat

Image

Return to “Microsoft Access & VBA”

Who is online

Users browsing this forum: No registered users and 1 guest

cron

© 2008 MAGIC RAT PRODUCTIONS
SEE ME ON FACEBOOK
Facebook