An event import splits East Hall into two categories because one row includes extra spaces. Keep the imported text in column A so you can trace the records.

Normalize the grouping label in a separate column

Enter East Hall with spaces around it in A2 and East followed by three spaces and Hall in A3. In B2 enter =TRIM(A2) and fill down. Both results should say East Hall with one space.

Visible space marks show three spaces between East and Hall before cleaning.

Illustrated input. The dots mark ordinary spaces.

Use length to check the invisible change

Compare =LEN(A3) and =LEN(B3). Expect 11 and 9. A nonbreaking space can survive TRIM. If an imported label still groups separately, check its character codes and normalize the specific separator in a copy. Keep intentional display spacing in the source field.

The cleaned label has length 9, down from 11.

Illustrated LEN comparison.

Related Microsoft Excel reference