If at all possible I'd like to do this without VBA, and I'd like it to work cross-platform in Win Office as well as Mac Office. My cumbersome method currently does both, but it's . . . cumbersome. If ...
Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...