I have a drawing with room tags that have Name, Area, Occupancy and Occupancy calculations listed in the block. I then did a data extraction to generate a table.

1: The first problem is that the sorting order is thrown off by the first digit in the number, so that 170 goes before 98 since 9 is higher than 1.

2: The second problem is that I'd like to sum the occupancy column and I get #### if I leave the suffix occ. in. Is there away to right the formula to ignore the suffix? The work around would be to eliminate the suffixes from the tags, but i'd rather not have tags with just numbers. It's helpful to see the suffix to see what the numbers represent.

Thanks.