Hummm.. I follow the instructions but still cant
get it to work right...

My list is in A1 through A312

So I moved my function column to C1 and hit Fx

Then I enter in what they said =PROPER (A1)

Then it says copy the forumla, Well it is not
a forumula in C1, it is the name in the correct format,

When I copy it to B1 to B312

Alls I get is teh name in A1 for all...

Sam


--
fastblogs
------------------------------------------------------------------------
fastblogs's Profile: http://www.excelforum.com/member.php...o&userid=35118
View this thread: http://www.excelforum.com/showthread...hreadid=548727