0
votes
0answers
273 views

Simple find/replace for all xlsm and xlsx files in a directory

I have a directory with 20 spreadsheets. Some are xlsx and some are xlsm. I need to replace all instances of "foo", with "bar" in each sheet in each file. I'm using windows. I'm on Windows so I don't ...
0
votes
1answer
422 views

Natively Find & Replace with wildcards in Excel

Is there a way to natively use wildcards in Find & Replace, in Excel 2010? I'd rather not install an add-on if it can be avoided. For example: I want to be able to use a syntax similar to the ...
1
vote
2answers
2k views

Excel - find and replace images?

I exported a huge page from confluence into excel and it has a few columns that contain images. I need to convert them into text before I do another transition but this would be totally killing to do ...