Regex search and replace in Excel
Just imagine that you have a list (a long list) of names in a spreadsheet (no, it's not suitable for export and processing as a CSV) that are unhelpfully in the wrong format. In my case they looked like "FredBloggs" instead of "Fred, Bloggs".
If you happen to be using a decent, open spreadsheet this is easy to fix as …
Tags: excel regex technology