![]() |
Filtering
Hi
one way: - use a helper column - enter the following formula (assumption: col. A stores your part-number) =IF(AND(LEFT(A1,1)="R",ISNUMBER(--MID(A1,2,1))),"X","") and filter all entries with an 'X' in this helper column -----Original Message----- I have part numbers that start with RV RW RR... However, I only want parts that have an R and followed by a number.. R123456 R444444 I don't want any part that has a letter after the R... Thanks, DJ . |
Filtering
Thanks Chris
|
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com