Ravi Sir's Cards › Excel
Splitting text in older Excel
Revision card: Splitting text in older Excel. Example data table with Where is the space?: 4; Number part in older Excel: 500; Unit part in older Excel: gram.

Read card text
What this card says
Splitting text in older Excel
Example
data table with Where is the space?: 4; Number part in older Excel: 500; Unit part in older Excel: gram
Learn this in the lesson: Split Quantity and Unit in Excel (2 kg, 500 gram) with TEXTBEFORE, TEXTAFTER and NUMBERVALUE: Convert Grams to Kg