Remove or add special characters, line breaks with CHAR Function-Examples in Google Sheets and Excel

preview_player
Показать описание
🌟🌟NEW FREE ENGLISH QUIZZES🌟🌟

💰2000 questions
💰Basic, Intermediate, Advanced Level
💰Word Quizzes + Sentence Quizzes
💰Video Solutions for each answer
💰No login required
💰Enhanced your English vocabulary anywhere and anytime

***************************************************************************************************** Sometimes when we copy text from online, websites, emails etc. and paste the text we get special characters as well. We want to remove special characters with a formula. The CHAR and SUBSTITUTE functions can help you do that.

Time Stamps
00:00:00 Objective
00:00:15 Example of special characters pasted into a table
00:00:51 Example to remove special characters and line break from string

Let’s connect on social:

#GoogleSheets #MsExcel #englishlanguage #worddefinition #learnenglish #englishvocabulary #pronunciationguide #languagelearning
Рекомендации по теме
Комментарии
Автор

SUBSCRIBE to my channel for more informative content as I publish content DAILY.
COMMENT below what topic/s you would like to see more videos on and I'll publish content on your topic.
LIKE this video if you found it helpful.
SHARE with your teammates and friends to spread the knowledge and make your team efficient and knowledgeable.
THANK YOU for watching this video.

WHIZBUSTERS