4 ms·
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
by beastcoast 10y ago
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.
- auxym 10y agoVBA 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-regular-expressions-regex-in-microsoft-excel-both-in-cell-and-loops#22542835 http://stackoverflow.com/questions/22542834/how-to-use-regul... https://msdn.microsoft.com/en-us/library/ms974570.aspx https://msdn.microsoft.com/en-us/library/ms974570.aspx