Excel: Function to determine Alphabetical order of Two String Colomn

Hi Master Need your help please. First sorry for my bad english. I have two colomn contain string character, example like this: Colomn A1: Billy Colomn B1: Adam Which is wrong alphabetical order, so in Colomn C1: equal to 0 It should be: A1: Adam B1: Billy Colomn C1: equal to 1 This in colomn C1 function that I want to ask, how to determine which one (A1 and B1) is the first in alphabetical order? Thankyou in advanced for your kind help. Manggo

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of July 29, 2017.

For more resources for Microsoft Excel