In C1: =RIGHT(B1,10) In C2: =LEFT(REPLACE(B2,1,FIND("Date",B2&"Date")+5,"")&C1 ,10) Copy down.
Forum Rules
Bookmarks