Sitemap

Home

Deletion tools

• Delete cells by condition in Excel
  • Delete cells by content in Excel
  • Delete cells containing numbers
  • Implicit duplicates in Excel
  • Remove duplicates in column without shifting rows
  • Remove duplicates in Excel
• Delete multiple phrases from text in Excel
• Delete words in Excel
  • Delete first word in Excel cell, delete first N words in cells
  • Delete multiple words from Excel cells
  • Delete repeated (duplicate) words in Excel
  • Delete the last word in Excel cells / delete the last N words
  • Delete words containing Latin characters
• How to remove formulas from Excel cells
• Remove characters from cells in Excel
  • How to delete text after a character in Excel
  • How to delete text up to a certain character in Excel
  • Remove extra spaces from cells (trim column) in Excel
  • Remove first N characters (from left) in Excel cells
  • Remove last N characters (from right) in Excel
  • Remove Latin characters from text in Excel
  • Remove numbers from text in Excel cells
  • Remove Punctuation in Excel — Keep Only Letters and Numbers
• Remove unnecessary columns and rows by condition
  • Delete rows in Excel based on one or multiple conditions
  • How to delete empty columns in Excel
  • How to delete empty rows in Excel
  • Remove duplicate lines inside an Excel cell
  • Remove empty lines inside an Excel cell

Finding tools

• Find phrases in Excel
• Find specific cells in Excel
  • Find cells by several conditions in Excel
• Find specific characters in Excel
  • Detect text characters
  • Find alphanumeric characters in Excel
  • Find bold text in Excel
  • Find numbers in text cells
  • Find uppercase or lowercase letters in Excel cells
  • Regular expressions in Excel | Find, extract and replace text
• Find words in Excel
  • Find words repeated inside cells
  • How to find words in Excel (by exact match)
• How to create a table of contents in Excel
• Techniques and instruments to find duplicate values in Excel

Data extraction tools in Excel

• Count characters inside cells
• Count words in Excel cells
• Extract characters by condition in Excel
  • Extract bold text from cells in Excel
  • Extract characters by their position in the cell
  • Extract first N characters in Excel
  • Extract last characters from cells in Excel
  • Extract letters (Latin) in Excel
  • Extract numbers from cells in Excel
  • Extract text after a character in Excel
  • Extract text before a character in Excel
• Extract phrases from text in Excel
• Extract words from text in Excel
  • Extract a given list of words from cells in Excel
  • Get the first words of Excel cells
• How to count certain cells in Excel
• Statistical metrics in Excel
  • ABC analysis in Excel
  • Count repeated values in Excel
  • Cumulative share (running percentage) in Excel

Change & replace tools

• Change Characters in Excel
  • Change case in several cells at once
  • Convert numbers saved as text to real numbers
  • Sentence case in Excel: capitalize first letter in all cells
• Change multiple cells at once in Excel
  • 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
  • Reverse text in Excel: flip characters in a cell
  • Text translation in Excel
  • Translate text in Excel with DeepL
  • Translate text in Excel with Google Translate
• Change words in Excel
  • Add characters before or after every word in cell
  • Lemmatize words in Excel cells
  • Separate numbers from text in Excel cells
• How to find and replace multiple values in Excel in bulk
• Math functions and procedures in Excel
  • Arithmetic actions and operations in Excel
    • How to add numbers in Excel
    • Multiply a column by a number in Excel
  • Rounding in Excel
• Transformation of ranges
  • Count unique values in Excel
  • Sorting data in Excel
  • Split a cell into rows in Excel

Joining and splitting data tools for Excel

• Bulk edit hyperlinks in Excel
• Combine all columns into one in Excel
• Combine all sheets into one in Excel
• Combining data in Excel
• How to merge CSV files into one
• Merge open workbooks into one in Excel
• Split an Excel sheet into multiple sheets by column value

SEM & SEO tools

• API integrations of !SEMTools
• Excel word combinations generator
• Extract URL from hyperlinks in Excel
• Google search suggestions – get thousands of them to Excel
• Import data from large CSV and TXT files into Excel
• N-gram analysis in Excel
• Open all links in Excel at once
• Parsing Title, H1, Description in Excel
• QR code generator in Excel
• Search cell contents in Google from Excel
• Slug generator in Excel: SEO-friendly URLs
• Web scraping in Excel
• Working with AI in Excel
  • ChatGPT in Excel: API setup
  • Claude in Excel: Anthropic API setup
  • DeepSeek API in Excel: setup
  • Gemini in Excel: Google API setup
  • LM Studio in Excel: local AI models
  • Ollama in Excel: local AI models
  • OpenRouter API in Excel: setup
  • Perplexity in Excel: AI with web search

MS Excel functions glossary

• ABS
• AND
• BIN2DEC
• CHAR
• CODE
• CONCATENATE
• CONVERT
• COUNTA
• COUNTIF
• DATE
• DATEDIF
• DATEVALUE
• DAY
• DEC2BIN
• DEC2HEX
• DELTA
• EDATE
• EOMONTH
• EXACT
• FIND
• GESTEP
• HEX2DEC
• HOUR
• HYPERLINK
• IF
• IFERROR
• ISERR
• ISNA
• LEFT
• LEN
• LOWER
• MID
• MINUTE
• MONTH
• NETWORKDAYS
• NOT
• NOW
• OR
• PI
• PROPER
• REGEXEXTRACT
• REGEXREPLACE
• REGEXTEST
• REPLACE
• REPT
• RIGHT
• ROUND
• ROUNDDOWN
• ROUNDUP
• SEARCH
• SECOND
• SEQUENCE
• SHEET, SHEETS
• Statistical functions in Excel
• SUBSTITUTE
• SUMIFS
• SUMPRODUCT
• TEXT
• TEXTSPLIT function
• TIME
• TIMEVALUE
• TODAY
• TRIM
• UNICHAR
• UPPER
• VALUE
• VLOOKUP
• WEEKDAY
• WEEKNUM, ISOWEEKNUM
• WORKDAY
• YEAR
• YEARFRAC

Excel for beginners: questions and answers

• Absolute and relative references in Excel
• Array formulas in Excel
• Count cells with numbers in Excel
• Count characters in a range of cells in Excel
• Excel hotkeys (keyboard shortcuts)
• Find the position of the first number in a cell
• How many sheets are in an Excel workbook
• How to count the days in a month in Excel
• How to create a hyperlink in Excel: 10 ways
• How to create the alphabet in Excel
• How to find, replace and remove asterisks in Excel
• How to split cells in Excel
• How to switch between sheets in Excel
• Personal Macro Workbook (PERSONAL.XLSB) in Excel
• Search from the end of a string in Excel
• Special characters in Excel

Blog

• N-gram analysis in PPC

About !SEMTools

• !SEMTools Version History
• About author
• Buy !SEMTools license
• Download !SEMTools
• Free Features in !SEMTools
• How !SEMTools for Excel works