find and replace in Excel

Is it possible to do find and replace on a collection of cells in Excel? For example, I tried selecting a column that has cells with text in them and I looked for the letter a
but it did not find it even though there were many. I also tried just selecting the cells but not the entire column but still get that it does not find any.

Thanks.
onyourmarkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rodecaConnect With a Mentor Commented:
Well, it must work...

Check if there is some option inadvertedly selected: go to "Find & Replace" window, <Options...> button, and see "match case" option, "match full cell" option... (I don't know how they are spelled in English Excel)

HIH
RĂ˜




0
 
ukerandiConnect With a Mentor Commented:
you can use to folowing function find "a" in cells

=MID(B1,FIND("a",B1),1)
0
 
Patrick MatthewsConnect With a Mentor Commented:
In addition to checking whether you selected 'match case', also be sure to check whether you are searching in values or in formulas.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.