List wont go into a-z order correctly

[jono121ukk]

hi everyone i have a large list here and would like to get it to go into a-z order using the team name column.
it seams to do half of the list that another half.. cant see why it would do this ... any help please thank you

[Raphaelp]

The second half of the data has a space before the first letter. So it is sorting first everything A-Z without the space then everything A-Z with the space. To fix this, put =TRIM(B3) in A3 and fill down. Then select columns A thru D and sort on column A.

[leelnich]

Actually, there's a space (code=32) in front of half, and a "STICKY" space (code = 160) in front of the other.
Paste the following in A3 and copy down. Then sort columns A:D (on A).:
=TRIM(SUBSTITUTE(B3,CHAR(160),""))

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[protonLeah]

It also has leading non-breaking spaces in some cells. Use find alt-0160 and replace with nothing

[jono121ukk]

thank you for the help.

[jono121ukk]

YES it works thank you very much

[leelnich]

Happy to help! If you have your answer, please go to Thread Tools up top and mark your thread as SOLVED. Thanks!-Lee

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee