Thread: split 1.5/2.1 into 1.5 and 2.1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OkieViking OkieViking is offline
external usenet poster
  
Posts: 37
Default split 1.5/2.1 into 1.5 and 2.1
I have a cell with numbers in the following format 1.5/2.1. Is there a way
of picking the numbers out of that so I can populate two cells with 1.5 and
2.1?
Reply With QuoteReply With Quote