Thread: split 1.5/2.1 into 1.5 and 2.1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default split 1.5/2.1 into 1.5 and 2.1
'VBA
strData = "1.5/2.1"
Range("B1") = Split(strData,"/")(0)
Range("C1") = Split(strData,"/")(1)

'Worksheetfunction
=LEFT(A1,Find("/",A1)-1)
=MID(A1,Find("/",A1)+1,len(A1))


If this post helps click Yes
---------------
Jacob Skaria


"Okieviking" wrote:

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