Excel Mini Challenge: Clean File Names with TEXTBEFORE
- excelwizardd
- May 2
- 1 min read
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, "-")
📊 Use Cases:
File processing
Inventory lists,Client records,Submission logs Post it here : https://chat.whatsapp.com/DQ3Y2xan15zDIw3mTySF5D
📂 Download the Dataset: https://excelwizardd-my.sharepoint.com/:f:/p/contact/EhQ0P__8Zs1IqItHeoJIFroBryrGDEXnI0cTBs6MUMKXqQ?e=QvoptN
✨ Skip complex formulas — this is the modern way.
🧙♂️ For more smart Excel tricks → https://linktr.ee/ExcelWizardd
Comments