Wednesday, March 24, 2021

OIC - Use of Translate function

Requirements: To remove the aposthrope (') from a string.

Format:

translate($variable_name,"'",'')

We can also replace one special char to another one using translate function.

No comments:

Post a Comment

Featured Post

Microsoft Excel - New Excel functions for 2019 and microsoft excel 365 editions

Working... 📘 Introduction to New Excel Functions Microsoft introduced powerful dynamic array functions in Microsoft Excel 365 that are not ...