I am trying to sort only the left 6 characters of a column. I could not find
where I could select and sort only the first 6 characters so I created
another column 'B' and used the B1=LEFT(A1,6). I used the formula box to
verify format and the result was correct, but when I hit enter only ths
function showed in the cell B1. What am I doing wrong? It's driving me
crazy!