This project has moved and is read-only. For the latest updates, please go here.

Finding txt within.xls files

Feb 28, 2014 at 4:47 PM
It seems to scan through the subfolder but cannot find the 700+ xls files where some text needs amending. is it possible to find and replace |KR| in a spreadsheet Cell?

Many thanks
Feb 28, 2014 at 5:05 PM
I ticked skip binary detection it now find the files and supposedly makes the change but I can no longer open the files once its complete.
Mar 3, 2014 at 11:49 AM
Making changes in structured files like XLS document is pretty dangerous, since there maybe some meta chars or delimiters that may break.

fnr.exe works best with TXT or CSV files, so maybe best to export XLS to CSV, do replace and then import it back.

Eric