The TEXTJOIN is a new function introduced in 2019 and available in Microsoft Excel 2019, Excel 2021 and Excel for M365. The TEXTJOIN function combines the text from multiple strings …
How To Join Texts Using TEXTJOIN & IF Functions | Microsoft Excel Read More »
The String functions are used in computer programming languages to manipulate a string. Microsoft Excel also have many string functions which you can use to manipulate strings. The most basic …
String Functions : UPPER, LOWER & PROPER | Microsoft Excel Read More »
VLOOKUP is a function in Excel that perform a vertical lookup by searching for a value in the first column of a table and returning for a value in the …
As an IT Professional you may have to deal with lots of data every day. I have seen many experienced IT admins spending quite lots of time on the activities …
Basic Excel Functions you should know to make your work life easier Read More »
