How to spilt a marco enabled text into differnet cell?

Good day guys,

I am a Macro noobs and i usually copy ready macro from google. And I currently working on a check printing excel for my company to print check. I have googled and extract this macro from an author and place into my excel. But i run into a problem which is, the returned text will exceed the boundaries,
is there a way to spilt the text, lets say from after "dollars " to another appointed cell?

appreciated for any helps. thanks.

Untitled.jpg

Please Login or Register  to view this content.

My Apologise.
This is the desired result I yearn.

my apologise.

I have attached the excel file but unable to compute the desired result I wanted to.

it only can compute the words into a cell.

I am trying to display from a Macro Spell currency

A4: Twenty Eight Thousand Eight Hundred Sixty Three Dollars
A6: and Sixty Cents Only.

instead of
A4: Twenty Eight Thousand Eight Hundred Sixty Three Dollars and Sixty Cents Only.


can someone please help ? really appreciated