In Microsoft Excel, it is possible to combine, or concatenate, different cells of data into one cell. This article contains two examples.
Simple Concatenation
The following formula combines data from cells A1, B1 and C1. Write this formula into another column, such as column D1:
=A1&B1&C1
or
=CONCATENATE(A1,B1,C1)
Add Spaces Between Each Column
The following formula combines data from cells A1, B1 and C1 and adds spaces between each set of data. Write this formula into another column, such as column D1:
=A1&” “&B1&” “&C1
or
=CONCATENATE(A1,” “,B1,” “,C1)
PS: If you have multiple rows just copy the formula to other rows.
written by MG
\\ tags: excel, Windows
To create a compiled list of unique records, follow these steps:
- Select the column titles above rows or records that you want to sort.
- On the Data menu, point to Filter, and then click Advanced Filter. If you are prompted as follows, click OK.
No headers detected. Assume top row of selection is header row?
- Under Action, click Copy to another location.
- Click to select the Unique records only check box.
- In the List range box, type or select the range of records (such as A3:H10).
- In the Criteria range box, type or select the same range of records (that is, A3:H10)
- In the Copy to box, type the address of or select the first cell where you want the information to be placed. Make sure there is enough room so you don’t overwrite pre-existing data.
Note You can only do this in the active sheet.
- Click OK.
written by MG
\\ tags: excel, Windows
OpenVPN+GUI (openvpn-2.0.9-gui-1.0.3) in client mode will connect to the remote OpenVPN server, but will not accept the routes. Error in the log is as follows:
ROUTE: route addition failed using CreateIpForwardEntry: One or more arguments are not correct. [if_index=18]
Route addition via IPAPI failed
Solution:
add the following to the end of the configuration (ovpn) file:
route-method exe
route-delay 2
written by MG
\\ tags: openvpn, Windows
Delete key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Explorer\VolumeCaches\Compress old files
like this http://marti.dimerge.net/blog/2008/08/20/remove-compress-old-files-feature
written by MG
\\ tags: compress, Windows
Start->Run->CMD
CHKNTFS/T:3
where 3 is the amount of wait time in seconds
written by MG
\\ tags: chkntfs, time, Windows
1. run regedit
Reduce the wait time for services to be killed
2. go to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control
set WaitToKillServiceTimeout to 1000
Reduce the wait time for user processes and applications to be killed
3. go to HKEY_CURRENT_USER\Control Panel\Desktop
set HungAppTimeout to 1000
set WaitToKillAppTimeout to 1000
Automatically end, terminate and kill user processes or tasks on shutdown or logoff
set AutoEndTasks to 1
written by MG
\\ tags: kill, shutdown
The quickest way to disable or enable is through the command line:
netsh firewall set icmpsetting 8 disable
and for enable:
netsh firewall set icmpsetting 8 enable
written by MG
\\ tags: icmp, ping, vista
Recent Comments