Category Archives: MS Office

Trim spaces in Excel using kutools

In this tutorial we will learn to perform some string operation like trimming spaces, change the case etc. Many time we are receiving data in excel file  in which we are facing errors like extras spaces between 2 words and some time words with Leading and Trailing spaces. If records is few then you can […]

1,102 total views, no views today

Import Data from SQL in Excel without third party tool

In this tutorial, we will learn to import data from SQL directly to Excel without using any third party tools and programming techniques. To demonstrate this scenario, i have used MS Excel 2007. 1,102 total views, no views today

1,102 total views, no views today