Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

This Excel video tutorial shows you how to extract text from cells. Specifically, this tutorial will show you how to pull any word from a cell in excel provided the words or characters are separated by spaces or by any other common character. This example is highly adaptable and this is also explained in the video tutorial.

This is a useful tutorial to view when you need to pull certain text from a large list of data which is formatted in exactly the same manor.
   Topics Covered
Extract Text from Cells
Separates Text Based on Number of Spaces in a Cell
Adaptable Excel Text Extraction Example
LEFT() Function
FIND() Function
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.