When creating hyperlinks in Excel, you may want to use special characters to create an eye-catching or unique link. While most characters are allowed in a hyperlink, some characters are reserved for use in HTML and cannot be used in a hyperlink. These characters are:
- <
- >
- "
- #
- {
- }
- [
- ]
- |
- \
- ^
- ~
- `
Some of these characters may be used if you escape them with a backslash (\). For example, the pipe character (|) can be used if you escape it with a backslash: \|. However, this is not recommended, as it can lead to confusion and errors.
