How do I delete text from a text string in calc

I have a column of addresses in a spreadsheet and I am trying to move them into three columns so I can print properly formatted address labels.

I need to bulk delete some specific text at the end of text of variable length in a column containing addresses.

Where is the answer?