CTRL A

@quick.tips45

25.0K followers · usually 16.7K views a post

Views

188.9K

Likes

6.6K

Comments

53

Shares

514

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.

8 videos4 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.

Free account

Transcript, structure and on-screen text

4 beats, a 119-word transcript and 3 lines of on-screen text — the parts you need to write your own version.

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