Quote:
Originally Posted by NoSparks
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