Ravi Sir's Cards › Excel
Split "500 gram" into number and unit
Revision card: Split "500 gram" into number and unit. Example data table with Number part: 500; Unit part: gram; Convert to kg: 0.5.
Read card text
What this card says
Split "500 gram" into number and unit
Example
data table with Number part: 500; Unit part: gram; Convert to kg: 0.5
Learn this in the lesson: Split Quantity and Unit in Excel (2 kg, 500 gram) with TEXTBEFORE, TEXTAFTER and NUMBERVALUE: Convert Grams to Kg