Applying a Single Formula Across Multiple Adjacent Columns

of how to nest these formulas for more complex data cleaning? Copying Excel Formats: Format Painter & More