Vlookup not working due to "bad" web data

[natalie]

Hello,

I am trying to get a vlookup to work across multiple worksheets that have dat
downloaded (or copied and pasted) from different websites. It seems that ther
are probably some formatting issues with the data.

How can I make the data uniform across all worksheets?

Thanks!

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

Include urls,etc

 

[natalie]

Don Guillett wrote on 03/08/2010 09:24 ET :

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

Include urls,etc
Don Guillett
Microsoft MVP Excel
SalesAid Software

"natalie" wrote in message

Don,

Thanks for agreeing to look at my file. But your email address is not shown
so I don't know where to send it...