View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Helenf Helenf is offline
external usenet poster
 
Posts: 8
Default how to select the first character in a cell and delete the rest

Hi and thank you in advance
I have a large spreadsheet where they have populated values like 3x3ml,
5x0.5ml etc. They are all pretty different. We only need the first numbers
before the x. How do I do this? Please help