5 Secret Tips for Text to Columns in Excel
40.5 هزار بار بازدید -
6 سال پیش
-
In this video, we show
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
6 سال پیش
در تاریخ 1397/02/02 منتشر شده
است.
40,514
بـار بازدید شده