Single line data into multiple rows

[selant]

I have datas in A column. For example A1 :

AB 1524 - AB 1457 - AB 4158

How can i turn this data into multiple rows into a different worksheet ( "-" character will be the split character and i would need to trim spaces in the beginning and end) such as following :

AB 1524
AB 1457
AB 4158

There are lots of data in source column A, which means the function i require needs to be in a loop format if possible.

Any helps appreciated.

 

[Special-K99]

Assuming there are only ever 3 codes on a row. . .

1) Text to columns with hyphen as delimiter
2) Use Helper column to trim spaces
3) copy and paste the extra 2 columns below column A

 

[selant]

hi special-k99 thank you for solution but its not fixed that a row contains 3 codes. It may differ more or less. May be 4 codes, or only single code.