Previous Topic Next Topic

Searching in Excel

Closed
Abbas - Jul 19, 2010 at 07:33 AM
rizvisa1 Posts 4478 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

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses