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
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 →