Text manipulation in Excel, how to do it and how it can save you time working in your spreadsheets!
This week’s hint and tip is on Text Manipulation in Excel. This is a section which is covered in our Advanced Excel course. On this course we look at other features which manipulate text too. Although Excel is mainly used for number analysis in business there are many good features within it to allow for text manipulation. There are a number of different functions in this area but we’re focussing on a couple in this hint and tip as well as a text feature. These are:
- Text to Columns option
In the video below you will see how both the functions can be used to work together. You will also see how you can use a feature called Text to Columns.
LEN and SEARCH
LEN and SEARCH are both text functions in Excel that can be very powerful when trying to manipulate text within your spreadsheets. In the example in the video below, both are used in a nested function to isolate a Christian name from a Surname.
Text to Columns Feature
Text to Columns is a feature in Excel which allow to be able to split a column of full names into 2 separate columns where the name is split into Christian name and Surname.
All of these are covered in our Excel training in Birmingham as well as Excel training carried out in other midlands counties and throughout the UK.
The video below shows you how to use these two text functions and the text to column feature in Excel and how they can be beneficial for you in your day to day work.
Take a look below at the video to find out more and then try it out on your own computer!
We hope you have enjoyed this hint and tip, why not take a look at some previous ones too?
We are seeking to complement many areas of our training with back up exercises and examples on our YouTube channel. Please feel free to subscribe to it for many more examples. You can subscribe by clicking here.
We train a host of companies for Excel training in Birmingham and the midlands and further afield.