Excel Converting Numbers to Text for Sorting

Sorting numbers and text in Excel leads to a lot of issues. With sorting, text, and numbers in the same column do not play well together. It is important to convert values or numbers to text so when you sort A to Z, the sort is correct. When you have numbers and text in the same column and do a Sort A to Z, the numbers will be sorted before the text. I demonstrate how to use the ISTEXT function with Conditional Formatting to find text in a column. I also use the T Function in Excel.

I used Copy and Paste Values to get the data converted to Text back into the original column.
Fields that should always be text include:

Social Security Numbers
Zip Codes
Product Numbers
Account codes
Account numbers
Customer numbers

#msexcel #exceltextfunction #chrismenardexcel #chrismenard

Chris Menard's website: https://chrismenardtraining.com

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!