View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chriswyn chriswyn is offline
external usenet poster
 
Posts: 1
Default from the text 4 pcs., how to remove only characters/text

Pls help me in the above subject i.e. from the cell contents in excel as "4
Pcs.", what is the formula to be used to remove only number and mention in a
separate cell. i.e. cell should contain only numeric value, not the text.