Seperating text, backwards to frontwards

[Adam]

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

 

[PY & Associates]

use text to columns to split the field by the "-"
add helper row 1
number the columns as you want them
sort/option/columns
OK?

 

[Adam]

You learn something new everyday!

Thank you