Find and select similar cells in Excel

Define the number of different characters

The utility lets you find similar cells in your Excel list. You are to define the number of characters that may be different between the value in the initially selected cell and the entries you want to find. You can search in the current column, table, or the active sheet.

Free download for:
2019 2016 365 2013 2010 2007
Learn more
This tool is part of
Ultimate Suite
Find Similar Cells for Excel 2019, 2016 - 2007

With Find Similar Cells you will

  • Set the number of different symbolsIt’s up to you to decide the maximum number of different characters in similar cells.
  • Select similar cells in the needed rangeGet the similar cells selected in the current column, table, or active worksheet.

How to find similar cells in Excel

   
Set the number of different characters
Set the number of different characters
Search in the current column, table, or sheet
Search in the current column, table, or sheet
The similar cells are found and selected
The similar cells are found and selected
Set the number of different characters
Search in the current column, table, or sheet
The similar cells are found and selected

License benefits

Our customers get

Unconditional 60-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license for 2 or 5 PCs
or 1 server
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Find Similar Cells

This tool is part of Ultimate Suite
Read more about Suite

Supported versions

 

Excel

  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close