Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns. Or I want to extract "hours" field from "Task" column in below picture: (Extract hours field in … Continue reading Good Tip – Flash fill in Microsoft Excel to recognize and fill data for you automatically
Month: March 2019
Change screen resolution of macOS in Virtual Box
When you install macOS in Virtual Box, the screen resolution is predefined, say It's 1024x768. You are not able to change it via Virtual Box settings. In this article, I will tell you how to change the Screen Resolution of macOS in Virtual Box within two steps. Default screen solution is too mall compare to … Continue reading Change screen resolution of macOS in Virtual Box
How to config static IP address in Ubuntu 18.04 server with Netplan
Ubuntu 18.04 uses now Netplan to configure the network interfaces, so the configuration must be done in the file /etc/netplan/50-cloud-init.yaml sudo vi /etc/netplan/50-cloud-init.yaml DHCP address: network: version: 2 renderer: networkd ethernets: enp3s0: dhcp4: true Static address: network: version: 2 renderer: networkd ethernets: enp3s0: addresses: - 10.10.10.2/24 gateway4: 10.10.10.1 nameservers: addresses: [10.10.10.1, 1.1.1.1] You can find … Continue reading How to config static IP address in Ubuntu 18.04 server with Netplan
Hung Doan 