Sorry, I was trying to be concise. The actual application is this. I have a plug-in to Photoshop Lightroom that exports EXIF data for each photograph selected from the library.The data is reported as a.TXT file. I can copy the TXT file and paste it onto an Excel spreadsheet. Problem is that The data is presented as a long string with multiple data sets, Each with identical, repeating fields. What I want to do is to separate that long row into columns.then I would put headings on each column for shutter speed, aperture etc. I was thinking that I could place a character like a ; after each repeating data set and have Excel parse that data from the row and place it into columns. I believe this is possible, but I don't know how to do it.