It is quite common that we receive the data in Excel and several times we have to remove unwanted characters from columns or modify the data as per the requirement. To avoid manual fixes of these kind of requirements, we may use Macro to automate the process which not only increase productivity but also avoid manual errors. We can easily create Macro to quickly fix it. Here are the steps to create Macro and run it. Open Excel Goto View tab on Main menu Click on 'View Macros'. This should open a Macro popup. Enter Macro Name and click on + icon. Clicking on + icon should open Macro Coding screen(as shown below). Add your code in the function. Click on Save icon to save the file with Macro. Click on Run icon to run the Macro code. The above code should remove additional line breaks from columns. Reference Code(to remove line breaks from columns): Sub MyCustomMacro () Dim MyRange As Range Application . ScreenUpdating = False Application . Calculation = xlCa
What is Sitecore Powershell Extensions(SPE)? It is Sitecore accelerator which can drastically increase the speed to develop a Sitecore solution and helps you write script in powerful way. It provides a command line and scripting environment for automating Sitecore tasks. Is it Licensed tool OR free to download? If you have Sitecore license, these extensions are free of cost. How to install it? Installation For non-containerised environment click here For containerised environment click here You may download it from Sitecore downloads as well. Sitecore Powershell Extension Interface Why you need it? Rather writing everything in .Net code, Sitecore has provided provision to write powershell script which can work same way(as like C# code) and help building reports and automating tasks within Content Editor. Example of Powershell script Parent Script: Try { $currentItem = Get-Item . Import-Function Show-Page-Dialog $resultItem = Show-Page-