Changing text from one column to another

[alexaskmo]

I'm not sure how to formulate this so ill just paste and explain that way, i have a column that looks as follows:

Expeditionsärende telefon
Avbokat kundmöte
Expeditionsärende telefon
Bokning
Expeditionsärende telefon
Bokning
Expeditionsärende telefon
Expeditionsärende F2F
Genomfört kundmöte Webex
Avbokat kundmöte
Avbokat kundmöte
Expeditionsärende telefon
Bokning
Genomfört kundmöte telefon
Bokning
Genomfört kundmöte Webex
Avbokat kundmöte
Genomfört kundmöte Webex
Genomfört kundmöte Webex
Avbokat kundmöte
Expeditionsärende telefon
Avbokat kundmöte
Expeditionsärende telefon


What i want to do is rename all the "Expedition xxx" to only Expedition, "Genomfört xxx" to Genomfört, but everything else stays the same... any ideas? Also, i need this to be for the whole column, not a range since the data gets larger every week and i want this to happen automatically when i uppdate the data... Any ideas?

Added info: I need this to be done using a formula and i need the original data intact, so basically copying the one column to a new one with the wanted changes.