In partnership with Experts Exchange. Introduced in the 365 editions of Excel, the Let function lets you define variables, their values and calculations that use them, then use these to simplify complicated formulas. When you have a long formula that repeats a calculation several times, like an If function, Let
In partnership with Experts Exchange. Artificial intelligence is causing a major disruption in information technology. In this episode, we test how well three AI tools can help you create Excel formulas: ChatGPT, ExcelFormulaBot and Ajelix.
In partnership with Experts Exchange. Excel has a lot of ways to manipulate text, but finding specific characters starting from the end of a text string isn’t one of them. In this episode, we look at two ways to take a column of full names that includes middle names, middle
In partnership with Experts Exchange. Artificial intelligence is causing a major disruption in information technology. In this episode, we test how well three AI tools can help you create Excel formulas: ChatGPT, ExcelFormulaBot and Ajelix.
In partnership with Experts Exchange. If you have a survey with a list of yes/no questions, Excel can compile the answers of each respondent into a comma-separated list. Here’s how to do it using the IF, CONCATENATE and SUBSTITUTE functions together.
