if "44 HARRISON RD to 44 Harrison Rd" is on cell A1 you use the formula in ANY OTHER CELL than A1

=proper(a1)

If "44 HARRISON RD to 44 Harrison Rd" is on B1 you use the formula in ANY OTHER CELL than B1

=proper(b1)