I currently track the books I have read in a spreadsheet. I would now like to change how the existing entries look, so that if the title starts with the word "THE", the name of the book would would show as "Booklist, The".
My book title are in column B and I have worked out most of the formula, but can't get the first part of the IF statement to work. Here is what I want to do, in words for the book title in B2:
IF =LEFT(B2,4) equals "THE ",
THEN CONCATENATE(RIGHT(B2,LEN(B2)-4)," ,The "
ELSE B2
Help with the first part would be greatly appreciated!
Bookmarks