Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2015, 07:59 AM
Maxwell314 Maxwell314 is offline Need to extract all lines containing EA, EB, EC...EZ. (case sensitive) Windows 8 Need to extract all lines containing EA, EB, EC...EZ. (case sensitive) Office 2013
Novice
Need to extract all lines containing EA, EB, EC...EZ. (case sensitive)
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Why are message header rules are case sensitive delboy Outlook 1 10-10-2023 11:30 AM
Help with Case and Select case brent chadwick Word VBA 34 10-18-2015 02:13 PM
Deleting grid lines but keeping the axis lines CoffeeNut Excel 0 04-01-2013 01:50 PM
Case Sensitive (contains) Selection apolloman Excel 2 07-12-2011 04:50 AM
Need to extract all lines containing EA, EB, EC...EZ. (case sensitive) From all UPPER CASE to Proper Case davers Word 1 04-30-2009 12:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft