Hi I have a quick question regarding the if function combined with the left function.
My data set looks like this. I only need the left side before the deliminator but with a filter.
88-9999
98-1120
102-1100
102-1200
104-1200
104-1165
I currently have this to separate the first half...