Excel 365’s calculated columns offer this exact functionality, letting you focus on what truly matters—interpreting the data rather than getting caught up in the mechanics.

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...