excel help

Reply Subscribe

Thread Tools

May 9, 2005 | 11:59 AM

Grifter

Thread Starter

Senior Member

Joined: Dec 2000

Posts: 44,835

Likes: 0

From: the southwest

excel help

is there a way to get only the rows that have a particular string in them?
like to get all rows that have (T) at the end of the string:
8/13/1998 Norwalk (T)

May 9, 2005 | 01:29 PM

egghead

TF Plasti-crack Crew

Joined: May 2002

Posts: 1,086

Likes: 0

From: nj

Go to Data -> Filter -> AutoFilter. Click on the drop down at the top of the column and choose Custom. You can use equals *t) or ends with t). Text works find, but it doesn't seem to work with numbers.

May 9, 2005 | 01:33 PM

Grifter

Thread Starter

Senior Member

Joined: Dec 2000

Posts: 44,835

Likes: 0

From: the southwest

all the strings are different so a filter wont work

May 9, 2005 | 01:35 PM

egghead

TF Plasti-crack Crew

Joined: May 2002

Posts: 1,086

Likes: 0

From: nj

Using a custom filter for only the end of the string should work unless if you are looking for a lot of different endings.

May 9, 2005 | 02:17 PM

Grifter

Thread Starter

Senior Member

Joined: Dec 2000

Posts: 44,835

Likes: 0

From: the southwest

ok what i really need is to get all those rows into another file or sheet and keep the others in the original one
and in the end not have to use a filter

Last edited by Darth Grifter; May 9, 2005 at 02:26 PM.