To insert a dash between letters and numbers in Excel, use the following steps:
- Select the cell or range of cells where you want to insert the dashes.
- Click the Home tab.
- In the Font group, click the Insert drop-down arrow.
- Click Special Characters. A dialog box appears.
- In the Symbol tab, select the character you want to insert. In this case, select the dash (-) character.
- Click Insert. The character is inserted into the cell or cells.