How can you combine columns containing integers into a single column and include characters between them?

edit

You can use the CONCATENATE function or the ampersand (&) symbol in Excel to combine columns containing integers into a single column with characters between them. For example, if you have two columns A and B with integers and you want to combine them with a hyphen between them in a new column C, you can use the following formula in cell C1:

=CONCATENATE(A1,"-",B1)

or

=A1&"-"&B1

This will result in a new column C with values like "1-2", "3-4", etc.