|If your Names are being imported from another program, |
and your still having problems after using the =TRIM() function.
Try using the =CLEAN() function.
while =TRIM() removes only the Space Character,
the =CLEAN() function will remove other Non-printable Characters from your text.
If you have <non-printable>ABCD in a cell that will be 5 characters.
If you have ABCD<non-printable> in a cell that will be 5 characters
Use the =CLEAN() function to remove any non-printable characters.
Open up a new column next to your Names Column
then do a =CLEAN(D1) and drag it down as many rows as needed.
Then select the range of cells that you just entered the formula into and
This will retain the actual name minus any non-printable characters.