View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Khurram Khurram is offline
external usenet poster
 
Posts: 18
Default Capture a number from a cell containing numbers and letters

Hi all,
I need to capture the number from a cell that contains data in the
format "2.45 Days" or "3.6 Days". Is it possible to somehow remove the
"Days" elements and capture all else? I am doing this programatically
using VBA.

Thank you kindly

Khurram