Hands up if you’ve tried to download info from your bank, CRM or online app and it comes out an absolute mess!
It’s so frustrating when you’re trying to get some of your own data into Excel and it’s hard to make heads or tails of it.
The info is crucial for your small business, but the process gets thrown into the too hard basket.
It’s common for data to be downloaded as a CSV format (comma separated values) which dumps it all into one big messy column. Argh! You could spend hours separating it all out.
Well, there’s a way of cleaning it all up in less than 10 clicks!! Yup, no manual, line by line, pull your hair out, sorting. You can now spend more time using the info for analysis or decision-making instead.
Using the Text To Columns feature, you can split the info into separate columns based on a few clicks. There are lots of options to chose from to make the process as easy as possible.
Link to Formatting Numbers video: https://youtu.be/n20DDnZEMmg
Leave me a comment below on where you are watching from and whether you found this useful.
Don’t forget to SUBSCRIBE
// S U B S C R I B E :
YouTube | https://www.youtube.com/channel/UCXy1WoRT8qpH2jUgmFwDVlA
Podcast | https://anchor.fm/profitablesmallbusines
// V I D E O L I N K: https://youtu.be/n20DDnZEMmg
// J O I N F R E E F A C E B O O K P A G E :
www.facebook.com/groups/proftablesmallbiz
// S E N D M E A N E M A I L :
mailto:jitixa@jitixaraniga.com.au
// F O L L O W :
Website | www.theprofitablesmallbusiness.com
LinkedIn | www.linkedin.com/company/jitixaranigaconsultant
Facebook | www.facebook.com/jitixaranigaconsultant
Instagram | www.instagram.com/profitablesmallbusiness |@profitablesmallbusiness (new page)
// Brisbane, Australia
*** D I S C L A I M E R ***
The content is drawn from my experiences and opinions. Please seek specific advice from your accountant / professional advisor before implementing any changes in your business
#Business #Excel #TextToColumns #SplitColumns #SeparateColumns #CSV #Data
0 Comments