Cleaning data part 2 of 3 – Having numbers formated as text?
In this article, we'll be delving further into data cleansing and tackling the issue of handling numerical values presented in text format. It's not uncommon to come across numbers in text format, especially when dealing with exported data from sources like accounting systems or external data feeds. Such data might have numbers formatted as text or contain spaces between numerical values. In this session, we'll specifically focus on addressing the former scenario.