"Randy Tingley" wrote in message
t...



"Ron Rosenfeld" wrote in message
...

On Tue, 10 Apr 2012 19:36:35 -0400, "Randy Tingley"
wrote:

Good evening,
I am having an issue in displaying in the Excel Filter all records that
have
".." double period in the starting of the text.
The text in columns looks like:

column B

.xxxxxxx
..xxxxxx
€¦xxxxxx
.xxxxxxx
..xxxxxxx
€¦xxxxxxx
€¦xxxxxxx

and is approx 2000 rows.
The outcome should only show the ..xxxxxxxxx records.

Any ideas? Any assistance will be greatly appreciated.
Randy



One way would be to use the Advanced Filter

B1: Label
B2: First Record
B3: Second Record
etc.


Criteria Range (example)
H1:I2

H1:I1 leave these cells blank
H2: =LEFT(B2,2) = ".."
I2: =MID(B2,3,1)<"."

If you leave the cursor in column B, the wizard will likely select the
entire column.

Data / Advanced Filter

Action: Select either option as appropriate. Until debugged, I would
suggest "Copy to another Location"

List Range: $B$1:$B$2000 (or whatever range encompasses your data)
Criteria Range: $H$1:$I$2
Copy to: Wherever

<OK

Thank you!
I will try this!
Randy


Worked like a Champ!
Thank you!
Randy

On Wed, 11 Apr 2012 16:46:04 -0400, "Randy Tingley" wrote:

Thank you!
I will try this!
Randy


Worked like a Champ!
Thank you!
Randy

Glad to help.
Thanks for the feedback.