Hi all,
i want to find out number through find window Ctrl+F. i attached a file there are so many number but here is a sample for you. when i enter a complete number then search and i put short number like MD-RINT300181982 it is not find. i want remove ZERO because most of item ZERO Qty are different.
Thanks.
What exactly are you trying to do? Find will not work if the text string in the find box does not exactly match something in your list.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AliGW,
what is a solution for it? is there any possibility to find value quickly?
Thanks.
If I knew what you were trying to achieve, I might be able to help.
its simple to find out number like MD-RINT300181982 trace out. eliminate ZERO between. it is also show in pic. this number is available is given pic table. when you put complete number MD-RINT3001800001982 so it is traceable.
Thanks.
Try searching on the last 4 numbers only
Hi M,
In the "Find What" put *00018, i.e. star and the last 5 digits.
Does this help?
Regards
peterrc
Ignore....misread your postOriginally Posted by majidsiddique
Last edited by Excelski; 01-01-2019 at 07:10 AM.
Their is no record of 181982 last 6 digit in your data.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Hi AVK,
please review this pic. first item code MD-RINT30018 and after ZERO 1982 to search both of this combine to each other.
Both Excelski and peterre,
i have large data the last 4 or 5 digit is also part of other items so it is too difficult to identify only last digit. i know but i search this way last 4 digit is also attched in other item. like MD-INT3002200001982 here item is diffrent but last four digit is same. it is system generated report export in excel.
thanks.
Use the * wildcard.
MD-RINT30018*1982
Hi Andy,
Its working, ow-some,
Thanks a lot,
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks