Notepad ++(PlusPlus) Auto increment line numbering or symbol (bullet) to the text content using Column / Multi-Selection Editor

 Hi folks,

I was searching for automatically adding numbers for the content which is distributed in sequential lines

Sample Input

A

B

C

Multi-line Column Select

• Press and hold Alt keyboard button and drag the mouse cursor from top-bottom (bottom-top) in the same column (say column 1)
• Keyboard Shortcut: Press and hold Shift + Alt and Click DownArrow/UpArrow until the end of the column

Column / Multi-Selection Editor

1. Click Edit Menu
2. Select Column Editor (Alt + C)

Insert Number list

1. Choose "Number to Insert" section
2. Enter the values in "Initial Number", "Increased by" and "Repeat"
3. Check "Leading Zeros", if required

Insert Text

1. Choose "Text to Insert"
2. Insert the desired text/symbol

Format Selection

1. Choose the desired format
2. Default to "Decimal"

Please find the below image for your reference

Sample Output of auto increment number

1A

2B

3C

Sample Output of prefixing hyphen (-) to list

- A

- B

- C

Hopy this blog gives to explore more of Notepad++ editor. Happy hacking.

Please send your feedback and response to psrdotcom@gmail.com

Add (append or prepend) text along with excel functions/formula in a single cell

Hi friends,

Today I have come across a situation where i want to have the cell to descriptive and to have summation of some cells. I have got information on how to do it. Please find below

Input Data:

3

4

2

I want a cell to be on top those with description and summation value

Expected output data:

Sum = 9

3

4

2

To get the output, I have written the following function

Syntax:
="Text"& function

Example:
="Sum = "& SUM(A2:A4)

We can append and prepend the text to excel function to combine text and numbers as well.

Please send your comments and feedback to psrdotcom@gmail.com

Know Your Indian Train Reservation Berth Details Like Berth Position etc.

Hi everyone,

I booked my train ticket even it is in WaitingList. Because, I guessed that, It will get confirmed when chart prepares. After the chart preparation, my train ticket was confirmed with the berth number. They didn't put the information like, which berth it is? Is it Lower, Middle, Upper, SideLower or SideUpper.

I was curious to know the berth position. In the return journey, I thought like "why can't we know the berth position after having the berth number". And I just tried this logic in javascript because, you can give your train berth number and get the berth position in my blog itself.

Please enter your train berth number of Sleeper Class Or III Tier AC and click on the Disply Berth Position button.

I have created an Android application for this utility and its freely available in the market.
Android App supports from Android OS 2.1 Eclair and above.

You can download it from this link Train Berth Position Android App

Train Berth Position Android App

If you have a android smartphone with QR reader then scan the below QR code to redirect you to Google Play and download the app with in no time.

Please send your comments and feedback to psrdotcom@gmail.com