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

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

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!

[arvin]

What if im converting numbers with 4 digits and suffix? Tried your formula but it is only sorting the first digit.

[malanda]

do you sell propane and propane accessories? thank you for your content!

[Aartik]

te amo gordo, gracias! Encontre loque queria despeus de pelearme 1 hora con excel

[joshuawashburn]

im trying to sort numbers with letter prefix. like aisle numbers. A1-A40 but if i dont add a zero to the single digits, A30 comes before A4. it doesnt recognize the number as one or 2 digit. it sorts by the left most number no matter what