substituting two text occurances in same cell.

H

Hassan Alameh

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

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting just the time portion 6
Two columns followed by single page-width column on same page 0
Footnote references on one page, footnote text on the next 5
Problem with MS Word paragraph and character styles: format getting messed up 2
formula/version 2007 2
Function or Sub to help with text string 5
Using Style to create 11pt in paras but 8pt between paras? 0
Find/replace using wild cards to insert space between given characters 1

Top