Hi Hassan ,

Try this

=SUBSTITUTE(SUBSTITUTE(A1,"am"," am"),"pm"," pm")

Regards,
KL


"Hassan Alameh" wrote in message
oups.com...
Hi,

I have a long list of times entered as 8:30am - 9:15pm , where there
is no space between the time and the text am & pm.

Can I use the formula substitute to replace both the "am" and
"pm" with " am" and " pm" respectively,

i.e to insert a space between the time and text in a single formula?



is it possible to use OR to replace BOTH of them?



I would appreciate any help....



Thank you.