Format rows so they're evenly spaced

Hey guys. So I imported some data from word to excel (via copy and paste). Once everything was in Excel, I performed the necessary formatting to make sure everything looked nice... but there's one problem: one of the columns (categorized as "Last Name") is not lined up equally. For instance: there's approx 300 occupied rows: from row 1-10 everything looks nice and even when scrolling down. But then from 11-20 the names are positioned more to center of the cells than the first 10. It just doesn't look right or that organized. I tried aligning them but that didn't work.

How do I line up the column and make sure all the entries are positioned evenly? Hopefully I'm making sense. If not I can post a screenshot.

Thanks in advance!

Yes... Exactly. How do I get rid of them?

Use the formula =TRIM(C11)
Trim removes spaces from the beginning and end of your data, as well as multiple spaces within.

Okay, take a look at my attachment.

Notice how the data in columns C and D are all uniformly placed. Column A is a mess though. It's just one word but I can't seem to make them fit evenly like in columns C and D. Trim method doesnt seem to work. I'll try it again.

Done.

I just want the first 10 rows of column A to be lined up like everything else.

Thanks so much for your help.

That looks great Martin!!

But one thing.. when I pull up the find/replace tab and in 'Field' hold down ALT while typing 0160 with my NUM LK on, nothing appears. Am I doing something wrong?

This is a little more frustrating than I thought. Martin you did it perfectly.. I just can't seem do relpicate the steps right.

Anytime I try to enter the alt-1060 in the Field space nothing appears.. so there's nothing to replace. I know I have NUM LK on but still nothing.