Ravi Sir's Cards › Excel
Text and date formulas: TRIM, TEXTJOIN, DATEDIF
Revision card: Text and date formulas: TRIM, TEXTJOIN, DATEDIF. Example data table with Remove extra spaces: "Ruhi Bagale"; Join the names in A2:A4: Amir, Salman, Rani; Full years from B2 to C2: 31.
Read card text
What this card says
Text and date formulas: TRIM, TEXTJOIN, DATEDIF
Example
data table with Remove extra spaces: "Ruhi Bagale"; Join the names in A2:A4: Amir, Salman, Rani; Full years from B2 to C2: 31
Learn this in the lesson: 3. Formulas and Functions