• MVP Logo
  • Recent Forum Posts

    NBVC

    Search string query

    Try:

    =ISNUMBER(FIND(" 1 "," "&A2&" "))...

    NBVC Yesterday, 07:16 PM Go to last post
    Xephon12

    Search string query

    Sorry, to clarify the free text box has letters as well as numbers in it. I can appreciate that method if I could isolate the number in it, it's usually...

    Xephon12 Yesterday, 06:44 PM Go to last post
    NBVC

    Search string query

    Maybe something like this?

    =IFERROR(B2+0=1,FALSE)


    where B2 contains the string to check....

    NBVC Yesterday, 02:18 PM Go to last post
    Xephon12

    Search string query

    Hi,

    I'd be really grateful for any help on this. I've scratched my head for quite awhile on it...

    I've got like 10000 entries...

    Xephon12 Yesterday, 01:36 PM Go to last post
    Pecoflyer

    Unable to run macro

    Hi and welcome
    Please,do not crosspost your question on multiple forums without including links here to the other threads on other forums. ...

    Pecoflyer Yesterday, 09:34 AM Go to last post