Рет қаралды 905,733
VBA/Macros Course (40% Discount): www.teachexcel...
More help: www.teachexcel...
Excel Forum: www.teachexcel...
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 www.TeachExcel.com You can also visit the forum there if you have any questions.
Have a great day!