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.