Skip to main content

Posts

Showing posts from May, 2020

How to combine multiple rows into one row in Notepad++ ?

How to combine multiple rows into one row in Notepad++ ? Let's say you have copied some data from some source and pasted into Notepad++. And now you got something like this. But you want to combine all the data rows into one rows. There could be many ways to do that. Here I am sharing 2 simple and quick ways to it.   Method 1 Select all the data rows which you want to combine as one row. And simply press Ctrl + J from keyboard,  Or Go to Menu Edit --> Line Operations --> Join Lines The benefit of using this method is, it automatically adds space between combined rows while making them as one . And you are done. Simple ! Isn't it ? 😃 Method 2 You can make use to find/replace feature of Notepad++.  Put the cursor to the first line and press Ctrl + h , it will open Replace window for you. Now enter  [\n\r]+ in Find what field. If you want to add a specific word or comma between 2 combined rows, enter that in   Replace with  field . Select Regular...

How to install TextFX Plugin to Notepad++ (32 bit) ?

How to add TextFX Plugin to Notepad++ (32 bit) ? TextFX is a powerful text management plugin, which a good bunch of in-built operations to manage/format your text in your Notepad++ file. It is not installed by default in your Notepad++. So here are the steps to install it quickly. Step 1: From Notepad++ menu bar, click Plugins --> Plugins Admin (You may see Plugin Manager based on NPP version installed) Step 2: Go to Available tab on Plugins Admin window. Search for TextFX Characters             Select checkbox, and click on Install button Step 3: It will ask to restart Notepad++. and you will be TextFX menu once Notepad++ is restarted. Or else you can download the plugin zip, and extract in your NPPs plugins directory. Tell us in comments if you find this useful. Subscribe for such post in future. Never Stop Learning. Have a Great day.

How to insert a blank row after each data row in MS Excel ?

How to insert a blank row after each data row in MS Excel ? So, you have MS excel sheet with many data rows and now you need to insert a new blank row after each data row. Selecting each data row and doing insert row is not feasible unless you have all the time in the world. Follow below steps get it done smartly. Step 1: Open your excel file Step 2: Add sequence number for each data row in adjacent column Step 3: Copy all the numbers in same column below. Step 4:  Now just Sort the sequence column from lowest to highest number Just delete the sequence column and you are done. :) Comment and share if you like this trick. Also don't forget to subscribe for more such tips and tricks. Never stop learning. Have a great day.  

How to Copy/Paste Same Text in Multiple Rows in Notepad++ File ?

How to Copy/Paste Same Text in Multiple Rows in Notepad++ File ?   We have following text file, opened in Notepad++. This file contains only 20 lines, but you may have a file with 200 lines or more. And if you want to do something like below, a series of manual copy/paste operation for each line will be time consuming and boring. But there is a quick way you can get it done very smartly. Here are the steps. Step 1 :  Put cursor to the line from which you want to start. This will be the first line where expected text will be added. Step 2: Press shift + alt + down-arrow from keyboard, until cursor expands till line to which you want to paste your text. Step 3: Go to menu Edit --> Column Editor , Or simply press keys alt + c . It will open Column/ Multi-Selection Editor window. Step 4 : Enter your text in Text to Insert box. Click OK button and you are done. If you want to add just one or two words, you can simply start typing after Step 2, and it will be added at ...