GOOGLE FOGLI tutorial 25: Funzioni Testo per ripulire i dati su Fogli

☕ Support me with a free donation ➜ www.paypal.me/FrancescaMartorana

📗 Request the material created specifically for this course, writing to me through the contact form on my website ➜ www.FantasticaMenteING.com/​ 🌍

⭐ Google Sheets #googlesheets - Video course in Italian 📊 Tutorial 25: Basic text functions to clean up data on Google Sheets ⭐

In this tutorial we will discover how to use the fundamental TEXT functions of Google Sheets to arrange and manipulate strings in a simple and professional way!

🎯 What you will learn in the video:

🟢 UPPERCASE(text) – Changes all text to uppercase
🟢 LOWERCASE(text) – Converts everything to lowercase
🟢 PROP(text) – Capitalizes the first letter of each word
🟢 TRIM(text) – Removes leading, trailing, and multiple spaces
🟢 CONCATENATE(text1; [text2; …]) – Joins strings without separator
🟢 TEXTJOIN(delimiter; ignore_empty; text1; [text2; …]) – Joins strings with a delimiter of your choice and gives the option to ignore empty cells.

📊 In the practical part, we fix a dataset with malformatted names, surnames, and customer codes.

Useful links:

Combine data with the CONCATENATE & or Preview Tips function in Excel ⮕    • Excel tutorial 7D : Combinare dati con la ...  

#GoogleSheets #GoogleSheets #texts

👍 Follow me on Facebook ➜ www.facebook.com/FantasticaMenteING

💙 Follow me on Instagram ➜ www.instagram.com/FantasticaMenteING

♪ Follow me on TikTok ➜ www.tiktok.com/@fantasticamenteing

📱Subscribe to the WhatsApp channel ➜ whatsapp.com/channel/0029VaKNJJeJuyAFbCxTau2S

🔔 To be updated on upcoming uploads, subscribe to the channel and activate notifications by clicking on the bell.

Thanks for following me!

💼 Eng. Fra