[solved] Recognize the astirisk * as a character and not a random

[kamelkid2]

im working on a spreadsheet to manage some IP addresses and ive run into something that i cant seem to do (non VBA)

im trying to set up a statement that if the cell contains any asterisks (such as 192.***.***.** or 212.***.***.** to name a few), to display a 0 in an adjacent cell, otherwise display the original ip address.

but as the asterisk reads as a placeholder instead of a character i cant figure out how to code around this and every number that begins 192 and contains nothing but asterisks (a large number of cells) - are all being incorrectly processed.

anybody have a simple solution?

[canapone]

Hi,

try to put a tilde ~ (alt+126) before the asterisk in the formulae


I've tried also a formula like the following (no tilde):

=IF(ISNUMBER(FIND("*",A2)),0,A2)



Hope it helps

Regards

[kamelkid2]

awesome. both worked great (i went with the second in the end)

just made my day a lot easier. thank you so much

[canapone]

Hi, thank you for the feedback.

I was to write tilde is very convenient using simple filters:

Example, contains "~*" to filter all the strings containing asteriks.

Regards