Tag Archives: Excel

Tip – Excel formula to convert Instance Name to Server Name

Below formula will give sub string preceding \

Posted in Script, Uncategorized | Tagged , , , , , | Leave a comment

Excel conditional formatting to highlight the difference between 2 data sets

I had a situation to provide differences between 2 data sets with most readable format to business, based on existing data and differences business will make a decision on next course of action. After multiple different experiments, I have provided … Continue reading

Posted in Productivity, Uncategorized | Tagged , | Leave a comment

Avoid Next Line character in SSMS results

Many a time we copy data from SQL Server Management Studio results pane into Excel while preparing reports and analyzing the data. One of the most common problem is handling Next Line characters. These characters disrupts the indentation of data … Continue reading

Posted in Productivity, SQL Server, SSMS | Tagged , , , , | Leave a comment