Excel Forum
Similar Content
Split Cells with Multiple Lines - Text-to-Columns using Carriage Return
Tutorial: How to split a cell by each line of data within it; this will put each line into its own ...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...
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



Excel Magic Trick #192: Extract Middle Name Text To Column


See how to extract the middle name in quotes from a cell that has last, middle and first name. Text To Column feature, Delimiter is quote symbol, Skip column 1 and 2.

Cool Trick for Data Extraction





Got a Question? Ask it Here in the Forum.