CODEWITHSUNDEEP
excelescaping
user3066571
user3066571

Reputation: 1471

Escaping Angle Brackets in Excel

I'm trying to create a table of PGP key names, many of which include angle brackets <> around part of the name. Excel attempts to creating email hyperlinks out of them, and I don't want it to. I've tried selecting the cells and removing formatting, but all it does is remove the hyperlink. If I enter into a cell and press enter, it deletes the angle brackets from the cell's data, and removing formatting doesn't restore them. Does anyone know how to force Excel to treat what I enter as literal string and stop trying to help me when I don't want it to?

Thanks.

Upvotes: 0

Views: 2182

Answers (1)

Aly Abdelaziz
Aly Abdelaziz

Reputation: 290

You can type ' before the data entry in the field, in this case Excel usually treats it as just normal string.

Upvotes: 1

Related Questions