In this video, we look at how to separate multiple lines of text into separate cells using Text to Columns.
5 more secret Text to Columns tricks - • 5 Secret Tips for Text...
We do not need VBA or Power Query (as great as they are) to get this job done.
We are used to providing Text to Columns with a delimiter such as a comma, space or semi-colon. Here that delimiter is a line break.
That is not a usual option with Text to Columns, but it is more than capable.
Find more great free tutorials at;
www.computerga...
** Online Excel Courses **
Excel VBA for Beginners ► bit.ly/2JvnnRv
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2t3netw
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
9 сен 2024