As above Marc L, but first use 'Replace' function for "'" and "!" with replacement e.g. "|", and then Split, and then a loop with 'IF' statement for Left(string, 2) = "\\", and then a 'Dictionary'.