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
Bookmarks