Can someone tell me if you are able to use wilecards with the IF Function. I am trying to see if a call contains a period. If so make the new cell true or false.
Thanks,
Stephen
Can someone tell me if you are able to use wilecards with the IF Function. I am trying to see if a call contains a period. If so make the new cell true or false.
Thanks,
Stephen
Does this help
Returns True if A1 has a .=ISNUMBER(SEARCH(".",A1))
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Another way would be
=COUNTIF(A1,"*.*")=1
My end goal is to have the cell display the word "link" if the other cell does not contain a period and the word page if it does contain a period.
With the suggestions you gave I can get to the final goal with an additional step but is there a way to combine them?
Thanks again.
With A1 containing the cell with, or without, a period
try this:
Is that something you can work with?![]()
Please Login or Register to view this content.
Fabuloso. It is awesome. Thank You.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks