* 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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac