Ok so I need to remove the name from a cell with other data in it.
so lets say data is in A2
here are some examples of what it can look like
what I have: The result I want
WEb Site - Sales - Tony Tony
Web - enquiry - Tony-Snith Tony-Snith...