How do you multiply cells with text and numbers in excel?

Answer 1

Normally, you do not. I recommend you put text and numbers in separate cells. You can modify the width of columns and join cells to format almost unlimited layouts on a spreadsheet, so there is no reason why you need to combine text and numbers in the same cell. Another option, is to enter the numbers as a separate entry in another column. You can hide the column, so the numbers do not show in the view or a printed report.

If you have an absolute requirement to combine text and numbers in a cell, you can extract the numbers with a custom macro. The algorithm would be to cycle through all the characters of the cell and save only those characters that are numbers, then copy the numbers to a separate cell where you can perform calculations.