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"
Each row has ...
Search found 2 matches
- Thu Aug 14, 2014 12:38 am
- Forum: TextPipe Tips and Tricks, Questions and Support
- Topic: Extract from Excel Cells?
- Replies: 3
- Views: 8104
- Wed Aug 13, 2014 1:50 am
- Forum: TextPipe Tips and Tricks, Questions and Support
- Topic: Extract from Excel Cells?
- Replies: 3
- Views: 8104
Extract from Excel Cells?
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 ...
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 ...