All posts tagged len

Sometimes sorting gets really frustrating when all the data you are trying to sort isn’t formatted the same.

Create a new column next to the column you’re attempting to sort, then use this formula to move X amount of characters.  I’m using Ford Part #’s and I need to sort by the 4th character in which is the Z

A2 cell = C0AZ-7153-A

Whereas x = the amount you want to move for example

which gives


From there just copy that formula to the rest of the cells in the new column then u can sort sheet under that column.