Automate the split part

[sachinkt]

In Google sheet Column “A2” there is some long text that I want to split and add the small parts B2, C2, D2, etc. I am able to do it using pabbly text formatter.

Now, When every time column new text in B3 Or B4 (incremental) is updated I want to automate the split part - B3, C3, D3 OR B4, C4, D4 respectively. how I can do it can anyone help?

 

[sachinkt]

Team, please respond I need it urgently. Thanks.

 

[Supreme]

Now, When every time column new text in B3 Or B4 (incremental) is updated I want to automate the split part - B3, C3, D3 OR B4, C4, D4 respectively. how I can do it can anyone help?

Sorry to say but you concern is not being very clear, so please explain it once clearly, so that we can look into it.

Regards!

 

[sachinkt]

I got the solution thanks