I’m trying to filter some data based on a ‘0’ being the middle character of a 5 character string. Trying a filter based on the usual wildcard character won’t work, as Like "*0*"
will pretty much pick up a zero anywhere. Can anyone suggest how I narrow things down to just that central position?
The string is always 5 characters?
Try https://support.office.com/en-us/article/Left-Function-d5897bf6-91f5-4bf8-853a-b63d7de09681
1 Like
I got an answer that works from someone in the office with way more chops than I. Apparently, the following works with a criteria of 0
. cost centre
is the column I’m filtering on
Expr1: Mid([cost centre],3,1)
I’ll get to explain how it works to me later.
Thanks for the link, it guided me towards this instead - https://msdn.microsoft.com/en-us/library/gg251677.aspx
Ah yes of course, MID, sorry
For some reason I thought you could give the starting position to LEFT as well
1 Like
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.