Everyone knows how well Excel handles numbers, but not everyone knows that Excel can work well with text as well.
As well as the live webinar recording I have added a quiz and some bonus videos.
This session covers Excel’s text functions. You will learn
- different techniques to split text
- techniques to extract text from text
- how to easily join text
- techniques for tweaking text for dates, numbers and upper and lower case
- the formulas for extracting sheet and file names
- two new functions in Excel 2016