I have my data on Google Sheets, and I need it on MS Excel.
Here is what I have tried.
Copy and paste (multiple formats like number, plain text, HTML).
I also copied and pasted it into an email and onto notepad.
I also directly downloaded the file from Google Docs as an XLSX
format, and that did not work.
On Google Docs it does not show dashes at all.
All of my data is zipcodes
My first sets of data are literally copied just like this.
Here is the HTML paste:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 100px"></colgroup><tbody>
</tbody>
Here is the PASTE VALUES ONLY PASTE
72103
72218
72406
0*2048
02181*
However, here are my actual results in Excel, which is a joke!
72103
72218
72406
0-2408
02181-
As you can see, the last 2 results listed below are completely wrong:
0-2408
02181-
Also, further down the list here is another zipcode
as it appears in Google Docs:
1*1250
1*2407
But instead read like this:
1-*1250
1*-2407
Please help!
Thanks!
Here is what I have tried.
Copy and paste (multiple formats like number, plain text, HTML).
I also copied and pasted it into an email and onto notepad.
I also directly downloaded the file from Google Docs as an XLSX
format, and that did not work.
On Google Docs it does not show dashes at all.
All of my data is zipcodes
My first sets of data are literally copied just like this.
Here is the HTML paste:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
72103 |
72218 |
72406 |
0*2048 |
02181* |
<colgroup><col style="width: 100px"></colgroup><tbody>
</tbody>
Here is the PASTE VALUES ONLY PASTE
72103
72218
72406
0*2048
02181*
However, here are my actual results in Excel, which is a joke!
72103
72218
72406
0-2408
02181-
As you can see, the last 2 results listed below are completely wrong:
0-2408
02181-
Also, further down the list here is another zipcode
as it appears in Google Docs:
1*1250
1*2407
But instead read like this:
1-*1250
1*-2407
Please help!
Thanks!