![]() ![]() ![]() The same can be done with the help of the CHAR function, where 161 is the character code for "¡" and 191 is the character code for "¿": SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( cell, char1, ""), char2, ""), char3, "")įor example, to eradicate normal exclamation and question marks as well as the inverted ones from a text string in A2, use this formula:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |