Find Wildcard, return that Wildcard value?
I have about an 8000 row file with a bunch of different group names
They all have a two digit code in them like AS, IP, AR, PO, etc.
I want to do a formula that looks for this like " ?? ", and then gives me that value in column B, so I can sort by specific module.
Help
So for example
[USA IP Requisition Processor][IP]
[Requisition USA GL Processor][GL]
[Processor USA Requisition AR ][AR]
[USA IS Requisition Processor][IS]
With your string in A1, try
="["&MID(A1, SEARCH(" ?? ", A1),4)&"]"
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi, Try this
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Another option:
=MID(A1,SEARCH(" ?? ",A1)+1,2)
Yes, if the codes are always two char as quoted in example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks