Remove characters from string

[Tom Ogilvy]

A functionality added after the last time I downloaded it - thanks for the
update.

 

[Ken McLennan]

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.

 

[Ron Rosenfeld]

G'day there Ron,


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