Reply To: Carriage Return in hyperlink

Inner Circle › Ask Smartsheet Guru Crew Anything › Carriage Return in hyperlink › Reply To: Carriage Return in hyperlink

January 30, 2025 at 4:43 pm #593
Darren
Keymaster

    Kevin,
    I found the issue. It isn’t apparent, but what happened is that in the text you have for the address, there are 2 special characters. One is the line feed represented by char(10), the other is a Carriage return represented by char(13).

    So, you’ll have to run another substitute on your text to replace char(13) with whatever character or “” to totally remove it.

    I got lucky and guessed that this was the additional character. I’ll need to look for a way to be able to see what special characters are there other than guess and check.

    I left some formulas in the sheet you shared in row 2.

    For a list of ASCII characters and codes see here: https://www.ascii-code.com/