Formula:add degree sign min sign and sec sign to a cell

Hi Raj,

Two different ways:
1. =C2&CHAR(176)&D2&CHAR(146)&E2&CHAR(148)
2. =C2&$M$4&D2&$M$6&E2&$M$8
Degrees Minutes Seconds display.xlsx
See the attached above:

Please try at I2
=TEXTJOIN({"°","’","”"},0,C2:F2)

or
=CONCAT(C2,"°",D2,"’",E2,"”")

of
=SUMPRODUCT(C2:E2/{24,1440,86400})
custom format h°m’s”

Hey Bo_Ry,

In your last SumProduct formula what happens with 100 degrees ?? I like your first two formulas, so the OP has 4 ways to solve his problem.

Good catch, Marvin

Custom format for sumproduct should be
[h]°m’s”

It isn't often I get a chance to find a mistake in your work. I'm still trying to understand some of the correct answers you've given in the past.