Extracting the address only to fit uptill 30 chara…

If you do the above to create a new column, you can find the last space using Length([REGEXFieldName],Findstring(ReverseString([REGEXFieldName]),” “)) and the data you’re after by wrapping the above with Left([Address],formula above) and then use that to create another field for the leftover: Trim(Replace([Address],[dataIwantedfield],””))

You may need to use Trim() a couple times in there and maybe a -1 to adjust for the 0-based array return…