Calling all Excel experts!

[phorsenuf]

I'm entering a whole bunch of info into Excel. Is there something I can do so that each time I type my first word into each column it will automatically capitalize it? I lloked under help and it talked about it buit didn't tell me how to do it. Any help would be sooooo greatfully appreciated!!!!!

(I'm cataloging 1300 books!)

 

[Bob Slydell]

Tools / Autocorrect -- there's an option under that where you can tell it to capitalize the first letter of a sentence.

The other option is to enter all the data and then in a new column, add the PROPER formula (this will capitalize the first letter of each word in the cell.

 

[phorsenuf]

Originally posted by Bob Slydell
Tools / Autocorrect -- there's an option under that where you can tell it to capitalize the first letter of a sentence.

This option is checked but it doesn't work. I tried it unchecked too.

The other option is to enter all the data and then in a new column, add the PROPER formula (this will capitalize the first letter of each word in the cell. [/QUOTE]

How do I do that (in dummy terms! LOL)
Thanks

 

[Bob Slydell]

Type in all the books in one column in whatever case you'd like (say Column A, for example). In Column B, you'd type the following formula: PROPER(A1)

Then copy that formula down the entire column of data.

 

[phorsenuf]

Originally posted by Bob Slydell
Type in all the books in one column in whatever case you'd like (say Column A, for example). In Column B, you'd type the following formula: PROPER(A1)

Then copy that formula down the entire column of data.

I must be real brain dead today because its just not working!

I type it in one column , then when I go to copy it into another it just then copies the words of the code. If I then type in that area, it doesn't capitalize anything.

I'm just doing something very obvious wrong. I hate when that happens!

 

[Bob Slydell]

Oops, sorry -- remember to add an "=" in front of the formula.

In other words, it should be =PROPER(A1)

 

[monkeyboy]

Originally posted by Bob Slydell
Oops, sorry -- remember to add an "=" in front of the formula.

In other words, it should be =PROPER(A1)

I was gonna say that there geekboy...errrr Bob

 

[Bob Slydell]

Originally posted by monkeyboy
I was gonna say that there geekboy...errrr Bob

That's weaselboy to you!

 

[phorsenuf]

ok, so I put this in column E PROPER(F1)

then I copy that and paste it into F column, right? If I do paste special and then check off formula, I get the same thing. When I do I get this...
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)

I swear, I usually have more smarts than this. Thats why I say I'm missing something very obvious.


WAAAAAAAAAAHHHHHHHHHHH

 

[Bob Slydell]

Originally posted by phorsenuf
ok, so I put this in column E PROPER(F1)

then I copy that and paste it into F column, right? If I do paste special and then check off formula, I get the same thing. When I do I get this...
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)
PROPER(F1)

I swear, I usually have more smarts than this. Thats why I say I'm missing something very obvious.


WAAAAAAAAAAHHHHHHHHHHH

You're missing the = sign

 

[weaselboy]

Originally posted by Bob Slydell
That's weaselboy to you!

ummm...i think that username is taken already.

 

[KathyTX]

If you are typing your data in column E, put your formula
=proper(e1) in column F

example:

type blue in cell E1
put formula =proper(e1) in cell F1
Blue will display in cell F1

 

[phorsenuf]

Originally posted by KathyTX
If you are typing your data in column E, put your formula
=proper(e1) in column F

example:

type blue in cell E1
put formula =proper(e1) in cell F1
Blue will display in cell F1

YAY it worked!

However, it just copied and capitalized everything into F1, so now I have 2 columns of the same info only one looks nicer. If I try to delete out the column I don't want anymore than it messes up my good column. I'm thinking I should just hide my bad column and be happy it worked. Or did I still do something wrong? LOL

Thanks so much for everyones help!

 

[Bob Slydell]

Originally posted by phorsenuf
YAY it worked!

However, it just copied and capitalized everything into F1, so now I have 2 columns of the same info only one looks nicer. If I try to delete out the column I don't want anymore than it messes up my good column. I'm thinking I should just hide my bad column and be happy it worked. Or did I still do something wrong? LOL

Thanks so much for everyones help!

Copy the "good" column of data and paste special (values). Then you can delete the other column.

 

[snoopy]

Gotta love the DIS -- I knew I saw this thread the other day, didn't pay real attention to it at the time, but lo and behold I'm trying to do this in Excel today and I thought of this thread.

Bob Slydell, wanna come work for my company? You are a heck of a lot more efficient than our help line!

 

[Bob Slydell]

Originally posted by snoopy

Bob Slydell, wanna come work for my company? You are a heck of a lot more efficient than our help line!

Help Desk???



No thanks!!