Hi guys, I have long list of names (about 5000), I would like to create a salutation column. I want the salutation result in the fourth column of my spreadsheet. Can someone please advise. Please see my list below. it would be great If the fourth column results like Mr Miller, Mr Lampitt, Pamela, Mr Vucich, Barney, Mr Newman, Naomi etc. I can use concatenate formula to get "Dear" in the front

Title First Name Surname
Mr David Miller
Mr C F Lampitt
Mrs Pamela Towers
Mr P J Vucich
Mr Barney Sowerby
Mr Thomas P Newman
Mrs Naomi ****
Mrs A A Ross
Mr M Rennie
Mr A Swney
Mr Patrick Webby

Much appreciated.
Cheers