*I am no responsible for your data, below is for helping only, use at your own risk

When exporting some data, sometimes you want to do a search and prelace and you get the dreaded “Formula is too long” crap. Here’s a workaround:

1) Make sure you can see extensions like *.txt, etc

2) Rename your *.csv with a *.txt

3) Open in word or other text editor capable of doing search and replace

4) Search and replace there

5) Rename your file back to *.csv

If you see your extension disappearing, it might be because your settings is set to something like to not show known file types in folder options