Copying data containing commas into excel

[stonysleep]

Am using Excel 2007 and every time I copy text from another database source (which is tab delimited without text qualifiers) where the data items have commas in the fields and paste it into excel it is delimiting the data based on the commas aswell as the tabs.
Is there an option somewhere to stop this as the reason there are commas is because they are names of the format:

surname, forename

I don't remember this happening in Excel 2003 but it is annoying as I have to paste the data into notepad and import it back in using the import data wizard to specify it as tab delimited.

 

[GlennUK]

See this:

http://www.mrexcel.com/td0129.html

 

[stonysleep]

thanks - thought there would be a simple answer to it