Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel file having keys and values. The values contain **.

How can I remove these asterisks when for them Find and Replace does not work?

I am using Excel 2010.

share|improve this question
add comment

migrated from stackoverflow.com Nov 28 '13 at 20:21

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 14 down vote accepted

Asterisk * is often a wildcard. To find a literal * it is necessary to escape the character, for Excel you use ~.

For example, to search for *, you would use ~*.

Same as if you were searching for ?, you would use ~?.

So to answer your question and search for **, you would use ~*~*.

From: Find or replace text and numbers on a worksheet

share|improve this answer
    
@random: Could you please confirm why my edit was reversed? As per THIS I was advised to ensure that I posted more than just a mere link... –  Siddharth Rout Dec 6 '13 at 9:34
    
@Sid Link is interesting - same mod deleted your answer to SO8934184 as deleted SO11348620. The latter basically the same as just asked SO20404573, which I doubt will be closed by 5 votes (or by any other mod). Hope you are better, SO has not been the same without you. –  pnuts Dec 6 '13 at 9:54
    
A whole page as an image means you still don't have any actual content to "read". It's all trapped in an image. The "no links as answer alone" means you need to include at least an applicable portion of the source/website/link on how it answers the problem, not just a link to read more. –  random Dec 6 '13 at 16:36
    
@random Logic? Sid was checking why from image (where more could be read) to link. You say not just a link to read more? So is the other answer (a duplicate, in my view) not an answer then? Apart from the somewhat extraneous ?, that adds nothing that was not in the post before it (answer) was submitted. –  pnuts Dec 6 '13 at 16:46
    
Comparing the two original versions of both answers, this one leaves out what the OP should type in, until another user edited in the actual answer. Again, do not screenshot a whole webpage and paste that as an answer. You cannot search text in images and you should always reframe answers instead of just copy-paste. Adding a link shows where you got the information from if you referenced it elsewhere –  random Dec 6 '13 at 16:51
show 2 more comments

Try replacing ~*~*. Single * characters are interpreted as wildcards, as are ? characters. The ~ before it 'escapes' these special characters.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.