Microsoft Excel - Delete

Delete all text after the first instance

Delete all text before the first instance