Hi All,

I have a field which is like the below example:


"Disappointed at failure - 68 Interior equipment - Repair group: Body -
..Archive"

Now I want to split this into fields, as per below:

A B C
D
..Archive Repair group: Body 68 Interior equipment Dissapointed
at failure

I know that I can use text to columns to split the field by the "-" but
then how do I get it reversed?

NOT all of the fields can be split into 4, sometimes there can be up to
7 or as little as 1.

Does anyone have an answer?

Regards
Adam