Hi

Sheet1, Column A as Names in the cells as in A1 John Smith, A2 Joe Brown
etc.
In Column T there is the same name in each row, yet the name is in a
Sentence.
How is a good way of checking the cells have the same name in each row.

A1 John Smith - T1 John Smith was out today (could have text here)

A2 Joe Brown - T2 Joe Brown was in today (could have text here)

A3 Albert Jones - T3 New Albert Jones on holiday (could have text here)

Etc

Thanks in advance

All the best

Dave

Thought for the Day:
"There are many ways of going forward, but only one way of standing still."
Franklin D. Roosevelt