Ravi Magham

Excel Data Get the last character in excel cell l using formula - like  to remove special character =RIGHT(A1,LEN(A1)-(LEN(A1)-1)) Extract all but last one characters from string Select a blank cell and type this formula =LEFT(A1,LEN(A1)-1)

SharePoint fixed table header  for SP 2010  https://sharepoint.stackexchange.com/questions/157621/sharepoint-fixed-table-header/164330#164330

Shortcut to open Instead of going to the Edit Properties form of the page, we can easily open the WebPart Maitenance page by just adding the following query string to the page URL ?contents=1 So, if your page URL is 'http://rams/pages/default.aspx' then after appending the query string it should look like '  http://rams/pages/default.aspx?contents=1 ' Source: http://www.spdeveloper.co.in/tipsntricks/pages/opening-webpart-maintenance-page.aspx https://support.office.com/en-us/article/open-and-use-the-web-part-maintenance-page-eff9ce22-d04a-44dd-ae83-ac29a5e396c2

How to Set a fixed or increase the width for a column in a SharePoint list view Add below sript using Snippet web part script src="/jquery.min.js" type="text/javascript" Source $ ( "TH.ms-vh2:contains('Column Name')" ). css ( "width" , "300px" ); https://sharepoint.stackexchange.com/questions/83159/adjusting-custom-list-column-widths https://olafd.wordpress.com/2013/11/30/set-a-fixed-width-for-a-column-in-a-view/ https://social.technet.microsoft.com/Forums/ie/en-US/06e06be6-8f88-4b1a-91a4-2837a77db1dd/sharepoint-2013-list-column-width?forum=sharepointgeneral

How Search or get the documents in subfolders of Document library in SharePoint Option 1  Using CAML Query below CAML query used to filter                     Sites /SiteCollectionName/SubsiteName/DocumentLibraryName/Folder Name/SubFolderName/SubSubFolderName/SubSubSubFolderName       Source https://sharepoint.stackexchange.com/questions/60495/caml-query-for-sub-folder-documents-javascript https://sharepoint.stackexchange.com/questions/59216/get-all-files-from-sub-folder-of-a-certain-content-type https://sharepoint.stackexchange.com/questions/215230/get-all-items-in-list-by-field-name-caml-query Option 2 Create a View which can point to SubFolder by changing the filter for the view using SharePoint Designer Source:  https://www.tombenjamin.ca/blog/designer/view/using-caml-query-show-files-folder/ There is a thread on  social.technet  where someone asks how to “Create a we...

Cascading Dropdown in SharePoint List using Infopath Forms/ REST Cascading Drop Down Lists in SharePoint / Office 365 using REST http://www.markrackley.net/2014/05/20/cascading-drop-down-lists-in-sharepoint-office-365-using-rest/ #Read more from source and copied from  http://www.sharepointdiary.com/2015/11/cascading-dropdown-using-infopath-forms-in-sharepoint-list.html#ixzz57m2lQArA Cascading Dropdown in SharePoint List using Infopath Forms What is Cascading drop downs? Well, Cascading drop downs are linked drop down controls where the content of the second drop down depends on the selection of the first one. E.g. When you Choose Country in the first drop down, the second drop down State is automatically filtered to the list of states actually in that county. Cascading drop downs are quite a common requirement and unfortunately, SharePoint doesn't support it Out of the box. In this article, I'm documenting the implementation of cascading drop down functi...

Remove item from ECB in SharePoint 2013 or Remove Delete item in Edit Control Block Solutions 1) If you simply want to hide, use the following CSS by adding in script web part   2) Java script ( not tested) source https://sharepoint.stackexchange.com/questions/114587/remove-item-from-ecb-in-sharepoint-2013 Related  links https://social.technet.microsoft.com/Forums/Lync/en-US/e91554ed-d057-4185-b1e7-e924f6eb79a4/how-to-hide-the-delete-item-option-from-the-list-item-menu-in-sharepoint-2010?forum=sharepointgeneralprevious http://www.learningsharepoint.com/2013/05/09/sharepoint-2013-callout-popup-tutorial/ https://docs.microsoft.com/en-us/sharepoint/dev/spfx/extensions/guidance/migrate-from-ecb-to-spfx-extensions http://www.learningsharepoint.com/2013/05/18/hide-callouts-in-a-sharepoint-2013-task-list/