Quite often I receive CSV files which ends up looking like crazy data in Excel – without columns. CSV is Comma Separated Values which means all the text is in one column, separated by commas. In Excel we use Text to Columns to split this text up into different columns (as it should be). It’s easier than you think – let me show you how and hopefully save you some time.

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found  https://tracyvanderschyff.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.

Advertisements