Hi Excel Community I have attached a file that in Column B, I have Alan Smith 02/04/2015 I require that Column C = Alan, Column D = Smith and Column E = 02/04/2015 What is the best formula to use please? Thanks