Hey everyone!

So I know to convert one cell from ALL CAPS to Proper Capitalization I use the =PROPER(A1) formula, but is there a way to do an entire row or sheet all at once?!

Any help would be very appreciated.

4/11/2007 3:33:40 PM

Yes. I could try to explain it but your head would explode. It'd be easier to just do it for you.

4/11/2007 3:42:07 PM

It's really that bad?!

Try me, sometimes I'm smart and catch on. I swear.

4/11/2007 3:47:36 PM

Quote :

"Sex : F Major : Political Science & Sociology & Philosophy"

this has little potential for success

4/11/2007 3:56:06 PM

manually type A2, A3, A4, ...


or just type the first 2, select them both, then drag down the corner

4/11/2007 3:56:10 PM

^^ That wasn't very nice. I use Excel everyday at work and am pretty efficient with it, just never came across this particular issue before.

^Thank you.

4/11/2007 3:58:35 PM

i always had a crush on you hayley!

you were my RA back in 2001.

4/11/2007 4:01:05 PM

thanks to work and degree, I earned my level 18 grand master of all things excel status

just fyi

for those of us who dont program code for a living, office is surprisingly almost all you need

------------
^ where was she an RA? I was thinking she looks REALLY familiar...

[Edited on April 11, 2007 at 4:01 PM. Reason : add]

4/11/2007 4:01:05 PM

I misunderstood. I thought you wanted to replace every cell in the workbook with something like:

Old cell: this is a test

New Cell: =PROPER('this is a test.')

4/11/2007 4:01:55 PM

you're pretty

4/11/2007 4:02:46 PM

^^^^ I was an RA in Alexander from 2001-2002, then in Lee Hall in the Summer of '02.

0EPII1, who are you?

^^I want to go from 'HAYLEY PHILLIPS' to 'Hayley Phillips' in every cell in the document.

^Thank you.

4/11/2007 4:05:39 PM

haha, doesn't matter... but i was in alexander, on a different floor, though.

4/11/2007 4:09:23 PM

Aw, come on!!!

4/11/2007 4:09:45 PM

Ohhhhh, thats definitely where I knew you from-- do you remember Sarah Manning and Chuck Allen? haha

I was friends with them, and then I also lived in like 902 lee that summer (02) also...

4/11/2007 4:13:30 PM

Yes!! Although I haven't had contact with them since around that time.

4/11/2007 4:14:59 PM

you can always copy and paste columns/tables into Word, and use Format-Change Case command, then copy/paste formatted text back into excel.

this is helpful when you have more than a single row to change case or want to make case changes that aren't built into excel. (and its actually quicker than messing around with formulas anyway)

4/11/2007 4:17:10 PM

^I can't believe I didn't think of that. Thank you!

4/11/2007 4:29:07 PM

Quote :

"into Word, and use Format-Change Case command"

in Word, you can also hit Shift+F3 to cycle through the case options

4/11/2007 4:58:27 PM

^ do you know where the complete list of Word keyboard shortcuts is? I know there are like 200 shortcuts, but most places only have common stuff like copy, paste, bold, superscript, etc.

4/11/2007 7:28:25 PM

1. On the Tools menu, point to Macro, and then click Macros.
2. In the Macros in box, click Word commands.
3. In the Macro name box, click ListCommands.
4. Click Run.
5. In the List Commands dialog box, click Current menu and keyboard settings.
6. Click OK.
7. On the File menu, click Print.

[Edited on April 11, 2007 at 8:01 PM. Reason : 

4/11/2007 7:58:50 PM

http://whatis.techtarget.com/content/1,290959,sid9_gci827341,00.html
http://www.fgcu.edu/support/office2000/word/shortcuts.html

4/11/2007 9:15:40 PM

yeah the directions i posted

contain 27 pages of possible shortcuts

4/11/2007 9:25:30 PM