I have exported data from quickbooks and one of the fields contains our clients' names, but it is preceeded by other information I'd like to delete. So the fields look something like "Teaching Tree:lastname, firstname"

How can I select a range of cells and have it delete only the "Treaching Tree:" from the fields and leave the clients' names?

Thanks!