Formula Max Character per cell + spread over other colums

[lily]

Hiii Excel Expert,



Let's say I have column A - address, and I have to divide it into 3 columns as each cell should contain max 30 characters (or digits)

Is there a specific formula to split the address into 2 or 3 columns?

Given:
Column A - Address over 90 characters
Column B = empty but only allows 30 characters
Column C = Idem Column B

To do:
Split address over 3 columns so each column contain max 30 characters.

For Example: a superlong address with flat and blok and tower name as well as district name

THanks a lot!!