Does anyone know of the best way to clean up a very large excel file?

intern profile

January 27, 2022

by an member from Wilfrid Laurier University - School of Business and Economics in Toronto, ON, Canada

I am working on cleaning up a 45k line excel file, pulling emails, phone numbers, addresses, etc. I wanted to know if anyone knows of a way to speed up this process, as it is very time-consuming to go through the file line by line.

3
9
77
Replies
9
commentor profile
Reply by a professional
from University of Dayton in Columbus, OH, USA
Depending on the state of the data - there is a number of different formulas you can use to extract the information you want. There are some freelance services out there but data security needs to be considered if you go down that route. Happy to elaborate if you want to message me.
commentor profile
Reply by a searcher
from University of Missouri in Charlotte, NC, USA
I'd be happy to take a look at a sample of the file and see about writing a few formulas. Been down this path many times in my banking days...

Feel free to message me
commentor profile
+7 more replies.
Join the discussion