Select Column A
Choose Text to Columns and choose the delimiter (most likely space or comma)

"dk" wrote:

We have a column that has first names sometimes last names we have another
column with last names you would like to remove all last names from column a
which is the first names column how can we do that?