Nowadays I find myself using excel as a ghetto tool for data munging: compare 2 lists with match(), copying tables from web tools and filtering them in creative ways. Text to columns is your friend. Also copy stuff into Notepad++ if I need to run a quick regex.
Comments
Nowadays I find myself using excel as a ghetto tool for data munging: compare 2 lists with match(), copying tables from web tools and filtering them in creative ways. Text to columns is your friend. Also copy stuff into Notepad++ if I need to run a quick regex.
Now if only Excel had good Regex built in.
VBA has access to "VBScript Regular Expressions 5.5", which is quite functional. I use it from time to time.
http://stackoverflow.com/questions/22542834/how-to-use-regul...
https://msdn.microsoft.com/en-us/library/ms974570.aspx