Help with creating an Excel formula starting with a cell with text and number

Hello. I am seeking help to create a simple formula to show ticket sales. My starting cell has a description of the ticket category with the price of the ticket. The next cell, in the adjacent colu...