Excel for the Web - Text to Columns - New Feature
Excel for the Web now has the Text to Columns feature available. If you have a list of names in column A that has first names and last names, for example, Chris Menard, you can now use Text to Columns to separate the names so you can sort by last name. If both names are in column A, you can't sort by last name.
I also show the desktop version of Text to Columns in this video.
Chapters:
0:00 Intro
0:28 Text to columns desktop
1:07 Text to columns web
1:49 Len function
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
#msexcel #microsoftexcel #chrismenardtraining #chrismenard