View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default text / formula help

Hi, trying to find a number within text, to do a calculation on it. Item is as:
:060101 at the left of a cell, with text following.

(if can treat as a date in another cell: to add/subtract 5 days, would be
the 2nd question).

thanks