Hi,

I have a list of accounts in column B. I want to add attach a value to column A based on the letter column B begins with. So:

Accounts beginning with all letters between A & F I want column A to return "Bob".
Accounts beginning with all letters between G & O I want column A to return "Tom".
Accounts beginning with all letters between P & Z I want column A to return "Harry".

I also want accounts beginning with numbers, to say "Bob" as well

What is the best way of doing this?

Thanks