substituting two text occurances in same cell.
 

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.

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.

You could also do it with Find Replace in two steps on the whole column,
in place, by replacing the "a" with " a" and the "p" with " p" without the
quotes.

Vaya con Dios,
Chuck, CABGx3


"KL" wrote in message
...
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.

It worked perfectly, Thanks alot dear KL,
i'm so grateful

:), missed that !!! thank u clr