​How to Split Text in Google Sheets under 30 Seconds #excel #exceltips #exceltricks #googlesheets

​1. Pehla Tarika: Split Text to Columns (Bina Formula Ke)
​Video ke shuruat mein (00:03 se 00:07 tak) bina kisi formula ke data alag karne ka smart tareeqa dikhaya gaya hai:
​Sabse pehle poore data (B column) ko select kiya.
​Upar menu mein Data par click karke Split text to columns option ko chuna.
​Neeche ek chhota separator box khula, jahan "Space" select karte hi saare naam ek jhatke mein alag-alag columns mein divide ho gaye.
​2. Doosra Tarika: =SPLIT Formula (Jo video ke aakhiri hisse mein hai)
​Video mein 00:15 ke baad creator ek formula likhne ki koshish karta hai. Pehle wo =TEXTSPLIT type karta hai, lekin aakhiri mein wo =SPLIT formula ka use karta hai:
Yeh formula kya karta hai: Yeh cell B2 ke text ko beech ke space (" ") ke hisaab se todkar alag-alag cells mein daal deta hai. Jaise hi ise lagakar Enter press karte hain, "Tech" aur "Gaming" alag alag ho jaate hain aur baaki cells mein autofill ho jaata hai.

Видео ​How to Split Text in Google Sheets under 30 Seconds #excel #exceltips #exceltricks #googlesheets канала Your formula dictionary