How do I delete text from a text string in calc

English
,
#1

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.

#2

Where is the answer?

#3

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.