Recent content by evilnick26

You're right! That does work but it gives a different square thing!! I'll try to explain; the one I got using your method (although imitating the original type cunningly!) does indicate a carriage return but the type I'm on about is the character *before* the carriage return. With the original...

Well, I'm not using a query or anything to get the data from Access (it was originally extractedn from a proprietary DB in the US and emailed as a zipped Access DB to me) I'm just highlighting rows in the table and then copy & pasting. I've found quite a time-consuming 'dirty' work-around using...

Geoff, Cheers for the quick response! I've tried doing that but I can't copy & paste the square character when it appears in Excel. I think it must be signifying a character rather than being a character itself, if that makes any sense?! Any more ideas? Nick.

Hello All! I work with large amounts of data that needs to be cleaned, usually in the form of big Access databases that are then copy & pasted (~10K records at a time) into Excel. The problem is that when I do this, sometimes I get a lot of "datadatadataŽ(then carriage...