How-To Geek on MSN

This hidden Excel tool can quickly clean up your data automatically

Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.
Hosted on MSN

How to extract numbers and text easily in Excel

In this video, we cover how to extract numbers, text, or other parts of a cell in Excel. We demonstrate extracting a number using flash fill with the CTRL + E shortcut, discussing its limitation of ...