Ever import file names like Order-234.csv and only need the prefix? TEXTBEFORE Here’s a 1-line fix that works perfectly: =TEXTBEFORE(A2,...