!SEMTools for Excel

EN

Menu

Author, contacts
Buy
Try for free

Features of !SEMTools

Find
- Characters
  - By type
  - By font style
    - Find bold text in Excel
    - Italic
    - Underlined
  - Find uppercase letters
- Cells
  - By substring match
  - By RegEx match
  - By occurence
- Words
  - Exactly matching
  - Containing
    - Beginning with
    - Ending with
    - Containing
  - By case
    - lower case
    - Proper Case
    - UPPER CASE
  - Find words repeated inside cells
- Duplicates
- Phrases
- Worksheets
Delete
- Characters
  - By type
  - By position
    - Delete first N characters
    - Delete last N characters
  - To occurence
- Cells
  - Delete cells containing numbers
  - Remove duplicates
    - Remove duplicates in column without shifting rows
- Words
  - Exact match
    - One word
    - Multiple words (from range)
  - Containing
    - Delete words containing Latin
  - By position
    - Delete first words in cells
    - Delete last words in cells
  - By RegEx
  - Delete repeated words inside cell
- Ranges
- Phrases
- Formulas
Change
Extract
- Characters
  - By position
    - Get first N characters in cell
    - Get last N characters in cell
  - By type
    - Extract letters (Latin) from cells
    - Extract numbers (digits) from cells
  - By font style
    - Extract bold text from cells
  - By RegEx pattern
  - Before substring
  - After substring
- Cells
  - Containing
- Words
  - Given list
  - By position
    - First
    - Last
- Attributes
  - Of text
    - Count characters inside cells
    - Count words in Excel cells
  - Of cell font
    - Font name
    - Font style
    - Font size
    - Font color
  - Cell attributes
    - Height
    - Width
    - Color fill
    - Borders
  - of dates
- Phrases
  - Place names
- Count
Join/Combine
- Join
  - CSV files
  - All open books
  - All sheets in active book
  - Ranges
  - Assemble hyperlinks
- Combinations
  - Line combination generator
SEO + PPC
- Change
  - Lemmatize words in Excel cells
- Delete
- Extract
- Search suggestions
- Semantic analysis
  - N-gram analysis (word frequency dictionary)
- APIs
  - AI tools in Excel

!SEMTools / Order Confirmation

Order Confirmation

Thank you for your order!

[profilepress-receipt]

© 2025 !SEMTools, Dmitry Tumaikin

Blog
EULA
Privacy Policy