Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

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.
0
onyourmark
Asked:
onyourmark
3 Solutions
 
rodecaCommented:
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
 
ukerandiCommented:
you can use to folowing function find "a" in cells

=MID(B1,FIND("a",B1),1)
0
 
Patrick MatthewsCommented:
In addition to checking whether you selected 'match case', also be sure to check whether you are searching in values or in formulas.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now