Skip to content

Latest commit

 

History

History
34 lines (25 loc) · 2.26 KB

README.md

File metadata and controls

34 lines (25 loc) · 2.26 KB
Raw

Excel-Cell-Checker

A few quick User Defined functions to bring the power of Regular Expressions to detect rogue text and characters in Excel. The primary goal of the project was to help detect the presence of Greek characters in Latin text and vice versa in an easy and user friendly way

We begin this project with a few simple functions:

  1. FindFirstLatin - The first match of a group of Latin characters (words) found within the selected (assumed Greek) text.
  2. FindFirstGreek - The first match of a group of Greek characters (words) found within the selected (assumed Latin) text.
  3. FindFirstRegex - The first match of the supplied .NET compatible Regular Expression pattern within the selected text.
  4. FindAllLatin - Returns a comma separated list of Latin characters (words) within the selected text.
  5. FindAllGreek - Returns a comma separated list of Greek characters (words) within the selected text.
  6. FindAllRegex - Returns a comma separated list of all matches of the supplied .NET compatible Regular Expression pattern within the selected text.

Installation

  1. Download the correct version for your version of Excel from the releases page:

    • Excel 32-bit: Excel.Cell.Checker-AddIn-packed.xll
    • Excel 64-bit: Excel.Cell.Checker-AddIn64-packed.xll

  2. In Excel, go to File > Options and follow the steps below to install the AddIn.

    Click on "Add-ins" and make sure "Excel Add-ins" is selected in the "Manage" list and click Go. Manage Excel Addins. Go to File > Options

    In the box that appears, click Browse Click Browse to find the xll file you downloaded in Step 1

    Locate the file you downloaded in Step and and click OK. Select the downloaded xll file

    That's It! You can now use the functions in Excel

Usage in Excel

Note on Regular Expressions

The FindFirstRegex and FindAllRegex functions are meant to be used with .NET compatible regular expressions including Exclusion groups! Special features of other Regex parsers will not work and might generate errors.