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 Excel Training in Birmingham: Excel icon​course we look at other features which manipulate text too. Although Businesses mainly use Excel for number analysis, there are many features within it to allow for text manipulation. There are several functions in this area but we’re focussing on two in this hint and tip plus a text feature. These are:

    1. LEN
    2. SEARCH
    3. 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 to use a feature called Text to Columns.

 

LEN and SEARCH

Firstly we will look at the two text functions LEN and SEARCH. LEN and SEARCH can be very powerful when trying to manipulate text within your spreadsheets. For 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 allows a column of full names to be split into 2 separate columns where the name is split up into Christian name and Surname.

 

These 3 features are covered in our Excel training in Birmingham courses as well as Excel training courses 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.

Watch the video below 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 our previous one on Formula Auditing in Excel?

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.

Please go onto our course web site page for more details or get in touch at johnlegge@jplcomputer.co.uk we’d be happy to help.

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy