Engineering functions – A to C
Table of Contents How to use the BIN2DEC function How to use the BIN2HEX function How to use the BIN2OCT […]

How to use the REPT function
The REPT function repeats a specific text a chosen number of times. Formula in cell D3: =REPT(B3,C3) Table of Contents […]

Extract specific word based on position in cell value
Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]

Working with classic ciphers in Excel
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

A Comprehensive Guide to Splitting Text in Excel
This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

How to extract email addresses from an Excel sheet
Question: How to extract email addresses from this sheet? Answer: It depends on how the emails are populated in your worksheet? […]