I'm trying to write a code to do the following:

1. Using text-to-columns,the data should get divided in different columns.
The data in Cells A1-A8 is like this:

[![enter image description here](https://i.stack.imgur.com/uqIgn.png)](https://i.stack.imgur.com/uqIgn.png)

This data should appear in different columns.