Previous Topic Next Topic

Searching in Excel

Closed
Abbas - Jul 19, 2010 at 07:33 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 19, 2010 at 08:41 AM
Hello,

I am having a 1500-2000 line item Product master list where in Electrical Mechanical Parts with their Part numbers and description are mentioned. Many a times the part number is mentioned as 214-126 and at time the same is written as 214126. Is there are way in Excel to search for 214126 and still show both the results

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jul 19, 2010 at 08:41 AM
You can use FIND with a wild card like

214*126
It wil find any thing that start with 216 and then may have another string but then ends with 126
0