loop to help manipulate text

I want to make a loop that can modify a column which contains a string with just a part of that string. For instance, a row could contain this person crossed at point a or the human came inside point a, and I would like to replace those with just "a" without the extra commentary.