Split one column into several columns

Text to Columns works until the data isn’t perfectly regular: one address has a suite number, another a comma less, and everything shifts one column to the right.

Here a column is split only when its pattern is unambiguous. An address column becomes Street, City, State and ZIP code, and an account path such as Assets:Current Assets:Checking keeps the account name with the full path in its own column. “Last, First” names and one column per account level are offered as one-click splits. Values that don’t fit the pattern stay whole in the first column and are flagged, so nothing lands in the wrong place.