Tag Archives: excel

Saving SQL Server Query Result In Text Format

Published on October th, 2012
Andri Kasta Marengga

Saving SQL Server Query Result In Text Format

Saving query result from SSMS is not easy as it seems, some of my colleague copy from SSMS query result and paste it to Excel. Apparently it’s not a problem, but it can be a problem if your data saved in text data type column but containing numeric data. If you paste this data directly […]

Continue Reading →

Excel Concatenate Error: You’ve Entered Too Many Arguments

Published on February th, 2012
Andri Kasta Marengga

Excel Concatenate Error: You’ve Entered Too Many Arguments

Yesterday i got this error when trying to put all the info from the hundreds cells that are populated into one cell. Cause: My arguments exceed argument limit of concatenate formula. In 2007 concatenate supports only 255 arguments. There are some resolution to get this done. Concatenate “Inception“. For example you’ll concat all Cells from […]

Continue Reading →