wildcards in formulaes

[paascal]

sorry for the stupid quesiton but i cant seem to figure it out :

i want to detect when cell has : anything+space+DASH+space+anything : 09/07/2021 - 6070608

i used =T63="* - *" still comes out as false

can someone smarted tell me what ive missed?

thaaaanks

[JohnTopley]

Please see yellow banner at top of page on how to attach a sample workbook.

And can you please update your profile with your location and Excel version: responses depend on knowing this information.

[AliGW]

Just use FIND:

=FIND(" - ",A1)

[josephteh]

Formula: =LEN(SUBSTITUTE(SUBSTITUTE(T63," - ","XXX")," ",""))>=5, assuming "anything" means "anything but space".

[Pete_UK]

Try it this way:

=COUNTIF(T63,"* - *")>0

Hope this helps.

Pete

[josephteh]

Formula: =LEN(SUBSTITUTE(SUBSTITUTE(T63," - ","XXX")," ",""))>=5, assuming "anything" means "anything but space".

Sorry.. wrong answer above. Try this: =AND(ISNUMBER(FIND(" - ",T63)),LEN(T63)-LEN(SUBSTITUTE(T63," ",""))=2)

[paascal]

guess i didnt ask the question correctly, i would like a true or false value to be returned if : " - " is found in a cell with any numbers or characters before or after

this is the type of format in the cell : 09/07/2021 - 6070608

[AliGW]

Try this:

=IF(ISNA(FIND(" - ",A1)),FALSE,TRUE)

[Pete_UK]

Did you try my formula?

Pete

[paascal]

yes yes pete wins! clapclapclap

i though =T63="* - *" would have worked... mind you two equals in one equation doestn make much sence. i just didnt know how to write it.

thanks

[Pete_UK]

Thanks for the rep, paascal.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete

[josephteh]

yes yes pete wins! clapclapclap

i though =T63="* - *" would have worked... mind you two equals in one equation doestn make much sence. i just didnt know how to write it.

thanks

Did you check that " - " is suffice without the "*" in the formulas? Do you want " - " (double spaces before and after "-") to be recognised as TRUE?

[josephteh]

Maybe a simple
=ISNUMBER(FIND(" - ",T63))

[josephteh]

Dear paascal,

It is not about who wins and gets the credit. It's disappointing that you failed to acknowledge the contributions by Ali and myself. You didn't mention what's wrong, if any, about our formulas.