To ignore all numbers stored as text, you need to open the Data tab and select the Text to Columns option. Then, select the Delimited option from the Convert Text to Columns wizard.

Power Query often automatically adds a ‘Change Type’ step after loading data to try and assign data types to columns based on the first 1,000 rows. If your data includes inconsistent types, such as ...

How to Capitalize Text in Excel Need to make a bold statement by converting everything to upper case? Excel’s UPPER function has your back.