Excel - Limit characters and move remaining text to next line

Question

Hello,

I am curious if it is a possibility to limit in excel the number of spaces/data characters to 30 per line and if more text is needed it automatically fills in the cell below?

For example. I have the statement "Thank you for reaching out. No one is available at this time and will circle back when we are able. In the meantime, feel free to reach out to our community, via VIVA engage. This can be reached at XYZ. You are able to utilize the search functionality, searching our public forums, that might be able to assist in the interim. Please know that your message is important and look forward to connecting soon. "

I am curious if it would be input a bulk text and break it down to 30 spaces/data characters per line and input the remaining text lines below in each cell. Example text below.

Thank you for reaching out. N

o one is available at this time

 and will circle back when we

are able. In the meantime, fe

el free to reach out to our com

munity, via VIVA engage. This c

an be reached at XYZ. You are a

ble utilize the search functional

ity, searching our public forums,

 that might be able to assist in t

he interim. Please know that yo

u message is important and look

 forward to connecting soon.

Any pointers or assistance would be greatly appreciated. Make it a great day!

Answer 1

=MID(A2,SEQUENCE(ROUNDUP(LEN(A2)/30,0),,0)*30+1,30)

Answer 2

This worked wonderfully. Thank you very much!!

Answer 3

You are welcome:) You may also give feedback on it.