Sort not sorting on 3rd column

[macRBC]

I’m having problems with sort a spreadsheet. Problem is it’s not consistently failing so hard to catch. Sort is being done on whole sheet, 3 columns.
Sort: Page# - LastName - FirstName.
results
01 SMITH Margareta
01 SMITH Andrea
01 SMITH Anton

[EarnestAl]

@macRBC

not consistently failing

Do those ones not sorted correctly have a space before their name? Try the TRIM function to remove leading and trailing spaces.
TrimBeforeSort125313.ods (15.4 KB)

[macRBC]

TRIM was applied. Same result

[Grantler]

Is sharing a sample file an option for you?

[macRBC]

Not sure what editing it was but after several sorts, the next one finally put the names in proper order. Thanks. (The TRIM was quite useful though, keep forgetting about those extra spaces)

[PKG]

@macRBC ,

If you don’t know how to upload files, just ask.