Help Request.

[gdrowell]

Hello again all,

I am adding names to a table that I copied and pasted from another application. The names copied fine, however, when i added a new row to type a name i missed, then sorted the table in alphabetical order, the name i added went to the bottom of the list and not in alphabetical. (Example: Brown, Carter, Green, Hopkins, Rowell, Bennett) . . . I indented the new name to match the indentation of the other names, yet, the new name added still goes to the bottom. Is there a fix to this, or do i have to re type all the names that i copied and pasted? Thank you for your assistance in advance.

 

[SteveO59L]

try trim() or clean() on your list

 

[gdrowell]

Tried them both separately and together. The leading empty spaces for the copied information still remain.

 

[gdrowell]

This worked
=TRIM(SUBSTITUTE(Cell address,CHAR(160),CHAR(32)))

Thank you so much for you help