Having trouble with this formula. In column A of Sheet1 i have a list of Log ID which show up either, MFG010318134515 or PURCH010318164059 which the numbers are time stamp and MFG or PURCH will be added via userform. What im trying to do is take all MFG Log ID and past into Sheet2 column a so...