By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select regexp_replace(substr(name, 1, 33), '^(.* )[^ ]+$', '\1') as first32,
substr(name, length(regexp_replace(substr(name, 1, 32), '^(.* )[^ ]+$', '\1')) + 1) as next32
from (select 'Some Random Very Long Comapany Name Co. Ltd.' as name from dual) x
| FIRST32 | NEXT32 |
|---|---|
| Some Random Very Long Comapany | Name Co. Ltd. |