On Mon, 29 Jan 2007 03:45:55 GMT, Ken McLennan
wrote:

G'day there Ron,

Actually, Longre's add-in can be easily embedded in the workbook, and
distributed with it. There is a menu option to do so.

Hmmm... If that's the case, then I guess I need to read up
on add-ins.

In this case, using regular expressions through VBA, it may be more efficient
to use the VBA method I posted or, if you want to use worksheet functions, to
rewrite it as a function.


If you do decide to use Longre's stuff as a function, you could use the same
pattern, and the formula would be:


=REGEX.MID(A1,"[0-9:]+(\s?[ap])?")


--ron