View Single Post
 
Old 11-05-2015, 07:59 AM
Maxwell314 Maxwell314 is offline Windows 8 Office 2013
Novice
 
Join Date: Dec 2014
Posts: 10
Maxwell314 is on a distinguished road
Default

Quote:
Originally Posted by NoSparks View Post
Post a sample sheet with your slow way and we'll speed it up.
Well part of it is done in excel then part is done with an online tool:

1) First I use find and replace: and I replace EA with -EA, EB with -EB, all the way to replacing EZ with -EZ. (case sensitive)

Basically just need to add the same symbol before every one. So things like EasyStreet.com won't have a dash (or whatever symbol) in front of it.

2) Then I use an online tool that let's me remove all lines not containing -.

Part one takes a bit and I have to do this many times sometimes...

Could there be a way to do this "find and replace" step in bulk?
Like all in one I could do
EA -> -EA
EB -> -EB
EC -> -EC
...EZ -> -EZ
Reply With Quote