Find/Replace NOT finding

[legreenwood]

I'm creating a database of prospects and have gleaned some info from the web. The problem is, the lists I copied & pasted have "Email: " prior to e-mail addresses and "Website: " prior to website addresses. I thought I could just find & replace these with nothing, but Excel doesn't see these prefixes. In playing with it I tried even just the colon or just "email," but it doesn't see any part of it. It did copy these in as hyperlinks originally but I removed hyperlinks - Find didn't work before or after removing hyperlinks.

Please help!

 

[scarey3]

Hi
I am trying to find AM and replace with 06-14 but keeps coming up with june-14 if I change the format to text it replaces it to 41791. is there a way that I can replace with 06-14 as in 06 in he morning to 14 in the afternoon

Thanks

Scarey