VBA Split string into multiple cells

[yits05]

Hello,

I have a string that is returned from an API call that is stored in "strresponse" as string. It can be more than 50,000 characters long. I would like to add some code to my script which splits the "strresponse" into multiple cells in a row, after 32766 characters. Appreciate any help!

Example of desired output:

Source code

source code

Source code

Response string characters 1- 32766

Response string characters 32766 - end

 

[rpaulson]

=left(strresponse,32766)
=mid(strresponse,32767,9999999)