Excel Forum

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.