Category Archives: MS Office

Trim spaces in Excel using kutools

rx online 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 […]

1,185 total views, no views today

Import Data from SQL in Excel without third party tool

rx online 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,160 total views, no views today

1,160 total views, no views today