Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

For Excel to divide the values, however, the cell must contain a delimiter, a character that specifies where the first number ends and the second one begins.

Learn how to multiply numbers in single cell, multiply multiple numbers from several cells, multiply column of numbers in Excel.