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
|