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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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