Extract Text from cells in Excel – How to get any word from a cell in Excel



Premium Course: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube

More help: https://www.teachexcel.com
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt

This tutorial shows you how to input a formula into a cell in Microsoft Excel which will pull text from another cell in the spreadsheet or workbook. This is not a macro but a formula.

This particular tutorial describes how to pull text which is separated by spaces. This means you can pull any word from a cell so long as there are spaces in front of it or behind it. This works well for large lists which are formatted exactly the same. Additionally, though this shows you how to extract text using spaces, you can use any distinct symbol or character in a cell to extract the text consistently over a large number of cells.

The functions used include LEFT() and FIND().

To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions.

Have a great day!

source

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.