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

Luke M


"curious user" wrote:

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 ?