Mixed numbers and text in a column - 4 ways to convert - Excel Tips
#DirtyData #ConvertNumbersExcel #ExcelTips
Ever have both numbers and text (that is numbers) in a column and want a quick way to convert everything to a number? You can use four simple methods to do this in Excel.
1) Paste Special (Add operation)
2) Text to columns
3) Formulas
4) Power Query