Excel Useful Features: Flash Fill & Text to Columns
In this video you will learn about some Excel useful features, including:
Flash fill: what it is and how to use it
Text to Columns: what is is and how to use it
The TRIM function and how to use it
In Excel there are many features that you can use to save time when creating your spreadsheets, especially when importing data. Sometimes when the data is imported, it might not be in the format that you want it to be in. To help with this there are some features to help in changing how the text appears in the cells. Here we are going to look at how you can use flash fill, text to columns and TRIM to change how your data is laid out in your spreadsheets.
Some related videos you might like:
VBA input message boxes in Excel - • VBA Input Message Boxes in Excel
Word useful features part 1 - • Word Useful Features Part 1
We also have a number of playlists on our channel that you might like to look at. One of these being on Data Summarising and Displaying in Excel - • Data Displaying in Excel
Our Excel useful features video is also included in our hint and tip post that can be found on our website - https://www.jplcomputer.co.uk/2020/12...
If you would like more information about us, pop over to our website here - https://www.jplcomputer.co.uk/
#MsOffice #MsExcel