How to quickly SPLIT text into columns in #Excel ?

preview_player
ะŸะพะบะฐะทะฐั‚ัŒ ะพะฟะธัะฐะฝะธะต
๐Ÿ’ฅ ๐—ช๐—ต๐—ฎ๐˜ ๐—ถ๐˜€ ๐—–๐—ผ๐—ป๐˜ƒ๐—ฒ๐—ฟ๐˜ ๐—ง๐—ฒ๐˜…๐˜ ๐˜๐—ผ ๐—–๐—ผ๐—น๐˜‚๐—บ๐—ป๐˜€ ๐—ช๐—ถ๐˜‡๐—ฎ๐—ฟ๐—ฑ ๐—ถ๐—ป ๐—˜๐˜…๐—ฐ๐—ฒ๐—น?
This feature allows you to take the text into multiple cells and split it into multiple cells. You can select the type of delimiter: comma, space, tab, between others.

๐Ÿ˜‰ Tip: While selecting the type of delimiter, you can have a preview of the result below.

๐Ÿ‘‰ In this video, we have split names, into first and last names, in two different columns.

---

๐Ÿ’ฅ ๐—ช๐—ต๐˜† ๐˜€๐—ต๐—ผ๐˜‚๐—น๐—ฑ ๐—œ ๐—ฏ๐—ฒ ๐˜‚๐˜€๐—ถ๐—ป๐—ด ๐—ฆ๐˜๐—ผ๐—ฐ๐—ธ๐˜€ ๐—ถ๐—ป ๐—˜๐˜…๐—ฐ๐—ฒ๐—น?
It's a very useful tool if you have multiple rows, and you would like to quickly get the final result, without the need to type manually.

*This feature is also available on Google Sheets under Data and then Split text to columns.

***

๐Ÿ†• More videos coming soon!

๐ŸŽฅ This video was shot with a MacBook Air.

***

#texttocolumns #excel #exceltrend
ะ ะตะบะพะผะตะฝะดะฐั†ะธะธ ะฟะพ ั‚ะตะผะต
ะšะพะผะผะตะฝั‚ะฐั€ะธะธ
ะะฒั‚ะพั€

Probably the fastest way to separate the content of a cell. Would you like to see how you can merge text strings from multiple cells? #excel

excel_trend