The dot operator and trim range function in modern Excel make formulas more dynamic, concise, and error-resistant, reducing the need for manual adjustments like dragging fill handles.

This repository demonstrates a common yet subtle bug in JavaScript where the '+' operator performs string concatenation instead of throwing a type error when different types are added.

V1.0 Add function that adds two values without using any math operator ( +, -, *, / ), just concatenation, .length and strings. This function was developed by me only as a challenge. Assemble a ...

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to fix the issue.

This post focusses on concatenating strings, but also shows how one of the operators (+=) also plays a primary role in incrementing numbers. Concatenating strings ...

ECMAScript 2021 highlights include replaceAll(), promise.any(), AggregateError, and new logical assignment operators, for starters. Let’s dive in.

It’s not easy keeping up with all the new features the ECMAScript spec brings us every year. Let’s catch up with the highlights from ES11.