This doen't seem to work because it's to complicated please just answer how
can we remove thw last word of whole column

"dk" wrote:

How can we split the last names to another cell ?
Als if we have Mr & mrs john doe mike how can we split the title ?