5 Secret Tips for Text to Columns in Excel

In this video, we show 5 secret Text to Columns tips. These examples are not taught by others, leaving Excel users unaware of some great tips. Text to Columns is used to split text in a cell over multiple columns. It is a great tool for manipulating text to get the data you want. It is capable of things though that 99% of Excel users do not know. This video explores 5 secret tips for Text to Columns. Timings for the video are: 00:00 - Introduction 00:20 - Convert text to numbers in Excel 02:00 - Convert numbers with a trailing minus sign to negative values 03:54 - Extract the first two characters 05:49 - Convert invalid date formats 07:20 - Convert US date formats to dd/mm/yyyy format Find more great free tutorials at; www.computergaga.com/ ** Online Excel Courses ** The Ultimate Excel Course – Learn Everything ► bit.ly/UltimateExcel Excel VBA for Beginners ► bit.ly/37XSKfZ Advanced Excel Tricks ► bit.ly/3CGCm3M Excel Formulas Made Easy ► bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm Connect with us! LinkedIn ► www.linkedin.com/company/18737946/ Instagram ► www.instagram.com/computergaga1/ Twitter ► www.twitter.com/computergaga1

• #howto_style
• #text_to_columns
• #computergaga
• #text_to_number
• #text_to_columns_in_excel
• #ms_excel_text_to_columns
• #excel_text_to_columns_date
• #excel_text_to_columns
• #how_to_use_text_to_column_in_excel
• #alan_murray
• #excel_shortcuts_and_tricks
• #text_to_number_conversion_excel
• #text_to_columns_in_excel_date_format
• #text_to_number_in_excel
• #text_to_columns_delimited_excel
• #excel_tips_for_accountants
• #split_text_into_different_columns_in_excel
• #how_to_use_text_to_columns_in_excel_fixed_width