Hello, Avril. My apologies - I did understand your advice on the splitting of the name field, I was going for one of the easier fields first. There are four division fields and I was trying to create a check for typos. I can get a formula [COLOR="Purple"](=IF(AND(J2<>"Automotive/LLP",J2<>"Retail",J2<>"Supply Chain",J2<>"Consumer, EM",J2<>"Life Sciences"),"Error","")[/COLOUR] to work but it means setting up four extra columns to report the errors (one column for each check) and my wife doesn't want this. I tried the formula in the appropriate part of a conditional format but it wouldn't work there.
You have confirmed my suspicion that the data in an email or SMS is different. Perhaps this isn't going to work at all. I have recommended that their system be made into a database but it has been a spreadsheet for so long that they do not feel they can change.
My thanks to you for your advice and suggestions. It has been fun trying to address the problem. Have a wonderful Christmas.