Hi Their, I am trying to manipulate data received from a csv file in order to create and import a journal in to Sage line 200. 00IT10021,1,31/05/2011,-1687.46,Trsf from ADM The above string reprersents the data I am trying to manipulate. The nine digit cost string (00IT10021) represents the 2 digit cost centre 00, the 3 digit department code IT1 and the 4 digit account number 0021. I need to seperate these 3 components into seperate columns in excel in order to create an import file. At present I am doing this manually by inserting comma's between each cost string, however, I have some files that are thousands of lines long and do not have the time or will power to insert commas in to all these lines. I hope someone can help Kind regards James