Where have my "s gone and how do I get them back?

[geewhysee]

I have data in notepad .csb format that looks like the sample I've pasted at the bottom of this post. However when I paste it into excel it looks like this picture ie the first set of quote marks is missing.

I think because the first "column" is a date excel is cutting out the quote marks even though I have selected text as the format for my cells. Any idea what is going on here?


"18-04-01","00:24:53.51","00","SMN","912053",0,"","07500813452"
"18-04-01","00:24:53.51","00","SMN","912053",0,"","07500813452"
"18-04-01","01:07:36.53","00","EML","141565",0,"",""
"18-04-01","01:07:38.31","00","EML","141565",0,"",""
"18-04-01","01:17:15.18","00","SMN","912059",0,"","07561454493"
"18-04-01","01:17:15.18","00","SMN","912059",0,"","07561454493"
"18-04-01","01:23:03.72","00","EML","141590",0,"",""
"18-04-01","01:37:31.70","00","EML","141590",0,"",""
"18-04-01","01:37:42.03","00","SMN","911982",1,"","07754395334"
"18-04-01","01:37:42.03","00","SMN","911982",1,"","07754395334"
"18-04-01","01:40:02.40","00","EML","141116",0,"",""
"18-04-01","01:40:04.46","00","EML","141116",0,"",""
"18-04-01","01:40:06.47","00","EML","141116",0,"",""
"18-04-01","01:40:08.24","00","EML","141116",0,"",""

 

[wideboydixon]

Apparently this is due to the TextToColumns setting. Use [Alt]+[F11] to bring up the VBA editor then [Ctrl]+[G] to go to the immediate window.

Type the following and hit [Enter]

Range("A1").Value = "0"

Then type the following and hit [Enter]

Range("A1").TextToColumns Destination:=Range("A1"), TextQualifier:=xlTextQualifierNone

Now go back to the worksheet and paste your text again.

WBD

 

[geewhysee]

This is great, cheers!