Split the text in multiple rows

[AsitabhaDeb]

Hi All,

I would like to split the data from multiple cell at a time. will it be possible .
First 5 alphabet from the text and paste in different column. 
From cell# F2 to F100 first 5 alphabet need to split and paste in column G.
Please help ASAP.

BR/Asitabha

------------------------------
Asitabha Deb
------------------------------

[Mukeshh_k]

Hi Shree,

If you could elaborate, is it comma separated or just the spacing in between the values ? i.e. Name, Policy Number, etc ?

How does it look like ? and if you could create a lookalike text file with few dummy entries in it that would help!

------------------------------

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------

[LeonardoSQueiroz]

Hello Shree Abhi !

Does the collection with the desired column pattern already exist or will it reuse the input file header?

------------------------------
Leonardo Soares
RPA Developer
------------------------------

[DevendranVenkatesh]

Please share the sample screen shot of input file for better understanding

------------------------------
Best Regards,
Devendran Venkatesh
RPA - Technical Architect |
Riyadh 11413, Kingdom of Saudi Arabia
Phone. +966-556784162
------------------------------