sorting

C

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 ?
 
L

Luke M

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