How can i split combined number and text in excel using formula?
If there is always a space betwwen the number and the unit of measure then
=LEFT(A1,SEARCH(" ",A1)-1)
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))
Regards,
Stefi
€˛John S€¯ ezt Ć*rta:
I'd like to split cells with a combined number followed by text as you find
in size and UOM information. For example it would split 220g into one cell of
220 and the other as g. For a cell with 400 ml then it would be 400 and ml in
the 2 cells.
|