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!

 

[Special-K99]

Dunno if this is the problem but when taking data from the web what appear as spaces are in fact CHAR(160).

 

[ADL87]

Hello,

It would be important to reproduce the problem on my computer so I could help you. I may not even be able to do that, but to start can you tell me your browser, excel version, and give an example of where/how exactly you copied one of the links? A second question is, if some basic excel functions aren't seeing that text, what other functions are ignoring that text? Is it actually messing up you filtering the data? Does it continue to copy that additional text when you copy and paste it to other cells?

One fix might be using Text To Columns and use ":" as the delimiter?

Let me know if Text To Columns did it for you, or come back with additional info please.

 

[legreenwood]

Thank you - I tried not using the space to see if it would find a portion of the part I want to remove, and got the same (no) result.

On a related topic, how do I get rid of the trailing space? I have another project where the data is from a csv file & there's a trailing space. I know it's a simple (few keystrokes) resolution but I can't remember the keys or sequence.

 

[legreenwood]

Above reply is to Special-K99

 

[Special-K99]

TRIM() should solve the trailing spaces.

 

[legreenwood]

ADL87 - thank you! I'm unfamiliar with Text to Columns & Excel Help yielded things that won't work for me, such as splitting the data. I have to have "hard coded" data so I can use the e-mail addresses for an e-mail blast, so if it's splitting the data that won't work for me (I'd be copying the formula instead of the data.) Forgive my ignorance - it's probably not what you intend yet it's all I could find in Excel Help. I'm using Excel 2013 in Office 365 & copied the data using Chrome. It doesn't affect filtering, and it does copy the additional text when I copy & paste to other cells. The countif function finds the word, while Find does not.

 

[AliGW]

Once the formula has done it's stuff, all you need to do is copy the results and paste them as values, then you will be copying, er, values and not formulae!

 

[legreenwood]

Awesome - I'll try it! Thanks again ADL87 & to you, AliGW!

 

[legreenwood]

OK that works GREAT - used fixed width to avoid the "non-space" space issue! THANK YOU ALL!!