top of page

Typing

Blog

Our blog covers all things Excel, aiming to make complex Excel concepts accessible and engaging to all Excel users, so whether you are a beginner or more experienced there will be something for you.

Many of our blogs have Excel files that you can download to follow along and get hands on experience applying Excel concepts.

If there's a particular Excel feature or function you're curious about, or if you have suggestions for topics you'd like us to cover please get in touch.

Search

Combine TEXTBEFORE and TEXTAFTER to get text between delimiters in Excel

Excel Navigator

Nov 242 min read

Combine TEXTBEFORE and TEXTAFTER to get text between delimiters in Excel

Nest a TEXTBEFORE function in a TEXTAFTER function to be able to extract text between two delimiters in text in a cell in Excel.

0 comments

Extract text in Excel with the TEXTBEFORE and TEXTAFTER functions

Excel Navigator

Nov 174 min read

Extract text in Excel with the TEXTBEFORE and TEXTAFTER functions

Extract text before and after delimiters in cells in Excel, and change the instance of the delimiter or output if a delimiter is not found.

0 comments

Dynamically format text in Excel with the UPPER, LOWER and PROPER functions

Excel Navigator

Nov 102 min read

Dynamically format text in Excel with the UPPER, LOWER and PROPER functions

Lear how to easily and quickly change text case in Excel cells using the UPPER, LOWER and PROPER functions.

0 comments

Use the TEXT function to format dates in concatenations in Excel

Excel Navigator

Oct 204 min read

Use the TEXT function to format dates in concatenations in Excel

Format dates in concatenations in Excel so that the date output shows in the format you choose rather than the underlying serial number.

0 comments

bottom of page