=--LEFT(A2,LEN(A2)-1) and format as time.
--
David Biddulph

"TrevorM" wrote in message
...
iliace

I have imported times from a database that have single letter extensions
e.g. 00:00a

The extensions are all different letters and I want to find and replace
them
with a blank to make the times workable in excel formulae.


"iliace" wrote:

And do what with them? Do you have an example?

On Nov 12, 7:16 am, TrevorM wrote:
Hi,
Is it possible to use Find Find /Replace to find all the letters in a
range?
Thanks