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?

Hi dk,

How can you know the difference between a first and last name?

E.g.,

James Simon
Simon James