Searching in Excel

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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