Hi guys,
This one should be easy...
Which formula in B1 checks if there is a certain character (to be specific, comma) in A1?
If I use "search" or "find", the formula returns "VALUE!" if the character is not there.
I need anything else - true/false or 1/0 or whatever.
Thanks in advance!
Last edited by Hitch75; 03-03-2011 at 12:53 PM.
Did you try:
Cheers,
Please Login or Register to view this content.
Last edited by ConneXionLost; 03-03-2011 at 12:43 PM.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Formula in B2 and drag down
A1 B1
theres a comma here, somewhere --- true
rheres a comma here somewhere --- not present
=IF(ISNUMBER(SEARCH(",",A1)),"true","not present")
Last edited by scottylad2; 03-03-2011 at 12:51 PM.
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
Both work!!
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks