Posts

Featured Post

Why Your 128GB USB Drive Shows Only 115GB: A Storage Mystery Solved

 Have you ever bought a 128GB USB drive, only to find that your computer shows it as 115GB or less? This isn't a trick or a manufacturing defect; it's a result of how storage is measured and formatted. The Decimal vs. Binary Conundrum Decimal Measurement: Storage manufacturers use the decimal system (base 10) to calculate storage. This means 1GB is 1,000,000,000 bytes. Binary Measurement: Computers, however, use the binary system (base 2), where 1GB is actually 1,073,741,824 bytes. This difference in measurement can lead to a significant discrepancy in perceived storage capacity. File System Overhead When you format a storage device, the file system (like NTFS or FAT32) takes up some space for its own operations. This overhead further reduces the usable storage capacity. Why Does This Happen? Marketing Practices: Manufacturers often advertise storage capacity using decimal measurements, which are easier to understand for consumers. Technical Limitations: The binary s

Removing Non-Breaking Spaces from Excel Cells: A Quick Guide

Many times there comes a scenario where we need to remove extra space from text in cell which has numbers in it, the Trim() function only doesn't work, we may need to use TRIM function combined with any other function (or) need to use VALUE function combined with any other function. Excel's  TRIM()  function is a lifesaver when it comes to removing leading and trailing spaces from text. However, it can be less effective when dealing with non-breaking spaces, which are often used to prevent text from breaking to the next line. The extra space is not a space it is a non-breaking space recognized as CHAR(160), to remove this non-breaking space need to use the below formula, VALUE(SUBSTITUTE(A2, CHAR(160),)) Example: If cell A2 contains the text "225422  " (with a non-breaking space after the number), applying the formula would result in "225422" with no extra spaces. By following these steps, you can effectively remove non-

Ubuntu 24.04 LTS

Ubuntu 24.04 Noble Numbat is a long-term support release that was released on 25 April 2024. It is based on systemd v255.4 and Linux kernel 6.8, which includes supports for more gamepads and better swap memory handling. As part of an upgrade to GNOME 46, many apps have been updated to use libadwaita and GTK4. Nautilus, the file manager, has received several quality-of-life features, and Wi-Fi settings now include an option to generate a QR code for network credentials. Notifications now include a header for the sender app's name, settings have been reorganized, touch users now tap to click by default, and users can now log in from a remote desktop.   GNOME Games is now never bundled on install. Thunderbird is now provided as only its snap version. The latest version can be installed from the official website  Ubuntu 24.04.1 LTS