![]() Selecting functions from the menus provides access to the Wizard dialogs that coach you through the syntax of each formula. If you prefer this function over the CONCAT function, look for it under Formulas > More Functions > Compatibility. ![]() In 2016, CONCATENATE is not shown on the dropdown list of Text Functions (under Formulas > Text). This means you can join the contents of several ranges: For example A3:C3, “ “, D3:F3 would combine the contents of cells A3, B3, and C3, to cells D3, E3, and F3 with a space between the two ranges.Ħ. According to Excel, it’s like CONCATENATE, but better, because it’s shorter, easier to type, and supports range references as opposed to just cell references. Note: In Excel 2016, there’s a new text function called CONCAT.
0 Comments
Leave a Reply. |