View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John S John S is offline
external usenet poster
 
Posts: 3
Default How can i split combined number and text in excel using formula?

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.