How do I search/find a substring that does not contain specific alphabet in a specific position. Is this possible
example: Find cells that
a)do not contain "t" in 4th position and
b)contains "r" in 5th position
excel query.jpg
Thanks
How do I search/find a substring that does not contain specific alphabet in a specific position. Is this possible
example: Find cells that
a)do not contain "t" in 4th position and
b)contains "r" in 5th position
excel query.jpg
Thanks
Please Login or Register to view this content.
Ben Van Johnson
Ok. But if i have to exclude a few more alphabets in the same position will this do
IF(MID(A1,4,1)<>"t","k","d", "h",A1,"")
Hi Samoth and welcome to the forum,
For both tests above try:
see the attached for some examples.Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Array FormulaPlease Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks