What?
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).
My Data:
Account ...
What?
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook).
How?
So for demonstration ...
What?
This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet.
Why?
The Excel file in question was about 36000 rows and had a file ...
What I have:
A CSV file exported from Excel along with double-quotes
label1,label2
item1a,item2a
item1c,"item2c,c"
item1b,item2b
What I want:
To read the file (stored on the server) and ...
... I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ).
Merging the lot
If B1 contains the coordinates and there is a space ...
What?
A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document.
How?
Open up a new workbook.
Get into VBA (Press Alt+F11)
Insert ...
... in the old column and which ones are new...
Why?
Consider the 3 following columns in an Excel spreadsheet:
Old New Exists in Old?
--------- --------- --------------
123456 234567
234567 ...
What?
This is a quick article on how to convert some cells in Microsoft Excel to number values...
Why?
OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...
What?
This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...
What?
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource.
Why?
If you are simply using a text file as your data source, then ...
What?
We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, ...
Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum:
Quick Count
=INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&"")))
...
The Situation
I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet.
The ...
So I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat.
The Situation
We have an Excel report which ...
Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue ...
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this:
I googled this for ages and found different suggestions ...
... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers):
//
// Generate a CSV of a ...
... a data table in ZohoAnalytics to hold the attachments
Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time
Add a dummy row with ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.