* in Escel

  steviegee 15:13 14 Nov 07

I have a spreadsheet with some cells containing *. If I do find * and replace with nothing it clears the whole sheet. How do I get rid of * without having to do them 1 by 1? Thanks.

  bstb3 15:21 14 Nov 07


Excel uses * as its wildcard character, hence the problem. This can be avoided if you put a ~ before it in the find box. So find and replace ~* will only replace instances of *.

  Karakorum 18:38 14 Nov 07

Would that be true of other MS programs or is it just an Excel trick?

  steviegee 07:41 15 Nov 07

Thanks bstb3 that worked.

  bstb3 09:24 15 Nov 07

As far as I know the problem only comes about in Excel. I tried Word and Access and edit/replace with a * changes only the *'s, it (the *) doesnt seem to act as a wildcard in the same way in those programs. Honestly cant comment about any other MS software other than those.

  Karakorum 22:29 16 Nov 07

Thanks for the comeback.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…