How to use dynamic values in text (Excel)
Learn how to use dynamic values in text in your Excel spreadsheets. Mix text and functions within cells easily and present professional tables to your colleagues or customers.
How to use the LEFT, RIGHT and MID functions
Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start in Excel or if you are an expert, this guide is for you!
Excel: How to split text into columns
If you need to extract data in Excel, you may want to use the Text to Columns tool. With only 3 steps, it’s really easy to split text into columns.
How to use the SEARCH function in Excel
How to search for specific data in Excel? Can I see some formula examples? How to find text in specific cells? And what’s the difference between FIND and SEARCH?
No worries, Ted Jordan is here to help!
How to use the IFNA function in Excel
Discover how to change #N/A errors in Excel! Change the value to a custom value easily.