CTRL A

@quick.tips45

28.4K followers · usually 14.1K views a post

Views

203.6K

Likes

7.1K

Comments

57

Shares

548

SoundTikTok sound · original sound - quick.tips45

Promoted product

Microsoft Excel

Create and edit spreadsheets online with Microsoft Excel for the web. Easy formatting, analysis, and real-time collaboration from any device.

26 videos13 creators

Why it worked

The video provides a quick and practical solution to a common data cleaning problem using readily available software (Excel). The use of keyboard shortcuts and the promise of a 'sheet' in the comments incentivizes engagement and sharing.

Summary

The creator demonstrates a quick method in Microsoft Excel to fix messy data by using the 'Text to Columns' feature. They show how to select all data with CTRL A, then use ALT AE and ALT HOI shortcuts to convert the text into organized columns, saving significant time compared to manual methods.

Structure

1Introduce the problem of a messy data sheet.
2Demonstrate the Excel shortcuts (CTRL A, ALT AE, ALT HOI) to fix the data.
3Show the result of the data being cleaned and organized into columns.

Original caption

#columns… ek hi cell mein 😵‍💫 Aisa data dekh ke koi bhi confuse ho jayega! But wait… Sirf 5 second mein clean table 💥 👉 Data → Text to Columns → DONE 😎 Manual karoge toh 1 hour lagega ❌ Excel se 5 sec ka kaam hai ✅ 📊 Real skills = Smart work 👉 Follow @codes.rahul for more insane Excel .#.. Read more

More from @quick.tips45

Call to action

Follow @codes.rahul for more insane Excel tips and comment 'sheet' to get the sheet.

On-screen text

CTRL A ALT AE ALT HOI

Transcript

Boss ne mujhe ye itni disaster sheet fix karne ko bola. Maine unse kaha ki isse theek karne mein mujhe pura din lag jayega. Lekin sach toh ye hai ki maine ise sirf 20 seconds mein fix kar diya. Aaiye dikhata hoon. Sabse pehla kisi bhi cell mein jaake CTRL A karke pura data ko select kijiye. Fir press kijiye ALT AE. Ab aap dekh sakte hain humne pura messy data ko columns mein clean kar diya. Press kijiye ALT HOI. Ab aap dekh sakte hain humne pura messy data ko columns mein clean kar diya. Agar ye trick achha laga toh follow @codes.rahul for more insane Excel tips and comment 'sheet' to get the sheet. Main bech dunga.