=proper(this.Cell)

[cipherus]

very new user to excel.

i have a spreadsheet with a list of 2000 or so names in all caps and i want to format them all to a name like Eddie (instead of EDDIE).

best I have come up with is =PROPER(A1) to make a whole knew column (one cell at a time) with properly formated names. but this sucks.

is there a function i could do like =PROPER(this.Cell) so i can drag the function across the whole list or something.

or maybe making a new spreadsheet to pull values from the other one? i couldn't get that to work at all though.

thanks in advance for any help!

[olasa]

This is easier then it looks.

Let's say all you names are in the column A and B. And you have written the formula =PROPER(A1) in cell C1.

If you put the cursor in C1 you will see that C1 is marked as a bold rectangel. However in the right bottom corner of that rectangle is a tiny small square.

If you double click on that tiny square, your formula will be copied down - as far as Excel can find names in column B.

You can also grab hold of the tiny square and drag-copy down your formula.

If anything goes wrong. Just use the undo button.

Ola

[cipherus]

when i put =PROPER(A1) in the C1 cell, then drag it down like you said, all the names that appear in the new column are the name in A1 over and over.

[cipherus]

actually i'm sorry, i was doing it wrong. that did work! but now when i try to copy out the newly formatted text into a new workbook it gives all #REF errors. is there a way for me to copy the text as if it was actual text instead of as a function?

[olasa]

Yes.
Mark all names in column C. Copy.
Put the cursor in column D
Then goto the Menu: Edit>Paste Special... and select Values. OK
That will get rid of the formula and leave the actual Text in col D.

Good luck
Ola

[cipherus]

YES!!! Thank you so much!