DataMystic

Thank you for your input. The excel workbook has 30 sheets. Is "Excel to Text" supposed to process all sheets in the range? As an output I am only getting a blank first sheet. The only populated column is column 1 so I do not need to remove anything with "Remove\Delimited fields"...

Hi there, I've just come across TextPipe & ExcelPipe and have been fiddling around with it so far pretty useful. However, I'm stuck at one filtering: What I would like to do is for either program to search for multiple strings (i.e. apple|banana) and return the contents of the matching cell from...