Find/Replace using ExcelPipe Home does find all characters

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators


Find/Replace using ExcelPipe Home does find all characters

Postby Brian » Mon Oct 31, 2005 5:44 am

I am a new user. The product appears to be very straight forward but I am still wondering why I have the following issue. I have a 1000 row excel spreadsheet that has numerous (tab or return character - a little box) listed within a text column. I want the special character to be found and replaced with a space - it appears to find some but not all. I have setup as many different combinations of this special character that I can think of and yet it still doesn't find them all. I have also tried to use the wildcard options but instead it replaces the entire field when the character is found instead of just the character. Any suggestions?[/img]

User avatar
DataMystic Support
Site Admin
Posts: 2140
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Postby DataMystic Support » Fri Dec 16, 2005 1:12 pm

Hi Brian,

Excel's search/replace is pretty limited. If the file is CSV or can be converted to it, use our TextPipe Pro for a much faster and easier solution.

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

Return to “WordPipe, ExcelPipe and PowerPointPipe Support”

Who is online

Users browsing this forum: No registered users and 2 guests