I'm working with a list where I want to filter the items that begin with "* "(a star then a space) and then have a string of letters and numbers after it (it is a model number).
I turn on the auto filter and I select "custom" for that column. I select "begins with" in the first drop down box and then type * in the second box and type. As I'm sure you know, that is the wild card indicator and I fail to filter out the other data. (I've also typed "*" and "* " to no avail).
Then I figured I try to do a find/replace on the * (this way, I thought, I could then just sort by what ever I replaced the * with) but I run into the same wildcard issue.
Do any of you have any good ideas on how to get around this little issue?
Thanks,
Steve
I turn on the auto filter and I select "custom" for that column. I select "begins with" in the first drop down box and then type * in the second box and type. As I'm sure you know, that is the wild card indicator and I fail to filter out the other data. (I've also typed "*" and "* " to no avail).
Then I figured I try to do a find/replace on the * (this way, I thought, I could then just sort by what ever I replaced the * with) but I run into the same wildcard issue.
Do any of you have any good ideas on how to get around this little issue?
Thanks,
Steve