Text Formatting

[Rodney]

How do I paste text into excel without the source formatting?
I am building a database but different sources (eg webpage) sometimes
overide the worksheet formatting.

 

[Sheeloo]

Try
Paste Special->Text