Community

Can't you open all files, then find a replace in all documents

eg find .+0.+\n
replace with (nothing!)

Obviously assuming here you are looknig to delete all lines with the string 000.

meant to add you need to open all files and select "all documents" in the find and replace dialogue box. I ...

Hi,

How can I change the text in more than 100 files to lower case? Is there some command or batch commands that I can use to do this for all files in a folder? Thanks.

open all 100 files
Find: .
Replace: \l&

(that's a lower case l in the replace)

Select all documents

Replace all.

Not sure ...

Thanks, I wound up just doing a query in Access :( We have an older version of Excel here that's limited to 66,xxx rows and in my version of Excel I would have needed 4+ different workbooks :lol:

I have Excel 2007 - can't believe I ever managed without it! Sometimes easier to jump to other ...

ok, i did get it to switch between documents by using CTRL + TAB but for some reason i can't get it to advance down my list of unique part numbers, it just stays on the first one indefinitely

I had a similar issue recently which worked itself out when I wasn't in block select mode - it seems to ...

Can't you open all files, then find a replace in all documents

eg find .+0.+\n
replace with (nothing!)

Obviously assuming here you are looknig to delete all lines with the string 000.