!SEMTools for Excel
EN
RU
Menu
How it works
Free features
Changelog
Author, contacts
Buy
Try for free
Features of !SEMTools
Find
Characters
By type
Find alphanumeric characters
Find Latin characters
Find numbers (digits)
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
Extra spaces
Numbers
Latin characters
Punctuation marks
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
Characters
Change case in several cells at once
Sentence case in Excel
Numbers
Arithmetic actions
Add
Multiply column by number
Divide
Words
Add characters
Lemmatize words
Separate text and numbers
Ranges
Cells
Text translation in Excel
Translate text in Excel with DeepL
Translate text in Excel with Google Translate
Add a character, word, other text to multiple cells in Excel
Change word order in Excel cells
Fill blank cells with zeros or values above/below in Excel
Replace
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/Split
Join
CSV files
All open books
All sheets in active book
Ranges
Assemble hyperlinks
Permute
Line combinations generator
Split
Sheet by column value
SEO + PPC
Change
Lemmatize words in Excel cells
Delete
Extract
Parsing Title, H1, Description in Excel
Extract URL from hyperlinks in Excel
Query CSV
Search suggestions
Semantic analysis
N-gram analysis (word frequency dictionary)
APIs
AI tools in Excel
↑ Навигация по задачам в Excel и возможностям надстройки !SEMTools ↑
Nothing Found
It seems we can’t find what you’re looking for. Perhaps searching can help.
Search for: