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 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.