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.
Bookmarks