How to Use the TEXTJOIN Function in Excel
The TEXTJOIN function offers a convenient way of concatenating values whilst separating them according to a specific delimiter.
-
-
Datestamps and Timestamps
Perhaps you are carrying out an audit or keeping track of a project in Excel. Datestamps and timestamps are bound to come in handy. Instead of manually entering the current date and/or time, use the following: • Ctrl + ;…
-
Why Every Excel User Needs Microsoft 365
Still got that old copy of Excel installed? Uninstall it, bin it (if it’s a CD-ROM), and get with the times. STOP being an Excel dinosaur! You’re Missing Out on the Updates You may not be aware, but unless you have…
-
How Excel Stores and Displays Data
For all the great things about Excel, one of the most confusing things is how it stores and displays data. Every cell has a number format, which can be selected from the dropdown in the Home ribbon tab. However, it…
-
How to Extract Unique Values in Excel
Extracting unique values from a range in Excel has always been possible, but not always easy. Only since the implementation of the new calculation engine has it become a doddle — thanks to the UNIQUE function. Having said that, for many years…
-
10 Features in Sheets Excel Needs
Excel is the behemoth of the spreadsheet kingdom. Across the length and breadth of every nation, it reigns supreme. As the market leader, the program has enjoyed a long stranglehold on its competition since dethroning the now-defunct Lotus 1–2–3 in…
End of content
End of content