.::.

Excel – Search for a character from the right

I want to extract “12C2” in string “D_CI-CC____-MY-12C2”

(1) Find position of “-” from the right: MATCH(“-“,INDEX(MID(A1,LEN(A1)-ROW(INDIRECT(“1:”&LEN(A1)))+1,1),0),0)

(2) Extract “12C2”: =RIGHT(A1, MATCH(“-“,INDEX(MID(A1,LEN(A1)-ROW(INDIRECT(“1:”&LEN(A1)))+1,1),0),0)-1)

4 May, 2016 at 9:49 am Leave a comment

Notepad++ Compare Plug-in

Click to download >> Rename .JGP to .ZIP

17 February, 2015 at 8:54 am Leave a comment

Export Google Calendar to Excel (free tool)

1. Open http://www.gcal2excel.com/
2. Grant access & Download

17 August, 2014 at 4:41 am Leave a comment

Change wi-fi display name and password (ASUS RT-N56U router)

1. Get IP of router’s admin interface (cmd –> ipconfig –> look at “Default Gateway” IP)

2. Type IP in web browser. For ASUS router:

• IP: 192.168.1.1
• username: admin
• password: admin

3. Go to “Wireless” panel, change SSID (username) and WPA Pre-Shared Key (wi-fi password)

4. Save/Apply

1 June, 2014 at 3:37 pm Leave a comment

[VBS] Count number of rows in text file

‘copied from internet

Note: No blank lines between lines

Set FSO = CreateObject(“Scripting.FileSystemObject”)

Set file = FSO.OpenTextFile(“C:\Documents and Settings\a5105628\Desktop\ITSR44952_aug11.txt”, 1)

file.ReadAll

‘subtract one ReadAll stops at the first blank line

msgbox (file.line)-1

4 October, 2011 at 10:55 am Leave a comment