Italian Excel formula
=SE.ERRORE(SINISTRA(A2;TROVA("_";A2)-1);A2)Useful Excel formulas
A quick guide with common Excel formulas, practical examples and both Italian and English versions.
English Excel formula
=IFERROR(LEFT(A2,FIND("_",A2)-1),A2)
Example
Example: amitraz_123 becomes amitraz. Use this page as an index.
Common error#NAME? error: the formula language may not match your Excel version.
Excel percentage
Excel formula to calculate a percentage VAT Excel
Excel formula for VAT and reverse VAT Dates Excel
Excel formula for date difference Text before character
Excel formula to keep text before a character Text after character
Excel formula to keep text after a character IFERROR
Excel IFERROR formula VLOOKUP / XLOOKUP
Excel formula to look up a value SUMIF
Excel SUMIF formula VLOOKUP
Excel VLOOKUP formula COUNTIF
Excel COUNTIF formula Trim spaces
Excel formula to trim spaces
Excel formula to calculate a percentage VAT Excel
Excel formula for VAT and reverse VAT Dates Excel
Excel formula for date difference Text before character
Excel formula to keep text before a character Text after character
Excel formula to keep text after a character IFERROR
Excel IFERROR formula VLOOKUP / XLOOKUP
Excel formula to look up a value SUMIF
Excel SUMIF formula VLOOKUP
Excel VLOOKUP formula COUNTIF
Excel COUNTIF formula Trim spaces
Excel formula to trim spaces
How it works
Excel formulas have different names in Italian and English.
Each page includes a ready formula, example and common error notes.
Frequently asked questions
Why does the formula return #NAME?
? Often because the function language is wrong.
Are the formulas compatible with Excel 2010?
Basic ones are.