sorting

[curious user]

if you have a column of data that looks like xxxxx.xx.xxxx.xx.xxxxx, how do
you sort on just the first 3 sets of characters: xxxxx.xx.xxxx ?

 

[Luke M]

You could make a second columns with the formula
=LEFT(A2,13) and then sort by that.