Thread: replace - with missing numbers (e.g 1-4 = 1, 2,3,4)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
  
Posts: 410
Default replace - with missing numbers (e.g 1-4 = 1, 2,3,4)
Hello, I am hoping that you can help me with a formula to replace a dash with the missing numbers. If I have 1-4 I would like to return 1,2,3,4.

Is this possible?

Reply With QuoteReply With Quote