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
![Automatically Extract BOLD Text with VBA [Adv. Excel]](https://images.videosashka.com/watch/wXJju5N4h58)
