View previous topic :: View next topic |
Author |
Message |
boanerges Blue Pill
Joined: Dec 04, 2006 Posts: 1
|
Posted: Thu Oct 18, 2007 3:30 pm Post subject: capitals |
|
I have a spreadsheet with lots of names, none are capitalized.
How can I cap the first and last names ( in separate columns). i am told one can do this in MS Office.
thanx. |
|
Back to top |
|
|
jgd Agent Smith
Joined: Feb 27, 2005 Posts: 1531 Location: France
|
Posted: Fri Oct 19, 2007 12:34 am Post subject: |
|
Select the columns which contain the first and last names.
Go to Format > Change Case menu and select Uppercase.
If you want to capitalize only the first letter in each name, it's a bit more complicated.
I'm out of time for the moment. Ask if it's that you want. I'll be able to help later.
Jacqueline |
|
Back to top |
|
|
yoxi Cipher
Joined: Sep 07, 2004 Posts: 1799 Location: Dawlish, Devon
|
Posted: Fri Oct 19, 2007 3:04 am Post subject: |
|
If what you want is to capitalise the first character of each name/word, then take a look at the bottom of this oooforum thread for an explanation of how you can use the PROPER() function to replace cell contents with their capitalised versions.
- padmavyuha
*edit* the 'Capitalise first letter of every sentence' option in Autocorrect doesn't work retrospectively - and in any case from v2.3 has been 'improved' so that it ignores the first word in a cell - I think your only way with this is a macro using PROPER() |
|
Back to top |
|
|
jgd Agent Smith
Joined: Feb 27, 2005 Posts: 1531 Location: France
|
Posted: Fri Oct 19, 2007 5:45 am Post subject: |
|
There is only a little problem in using PROPER(). You can't apply a function that modifies a cell content to the cell itself. So you have to go through empty cells, then copy/paste special in the cells you want to modify.
If you want to change names in column A from A1 to Axx, try this way:
Click in an empty cell, let's say C1.
Enter =PROPER(A1) in the formula bar. Press Return.
Then fill the range C1 to Cxx as described in this page in Neowiki.
Copy the cell range C1 to Cxx that you just filled. Select the range A1 to Axx, go to Edit > Paste Special…
In the Paste Special window, uncheck Paste all and Formulas. Click OK.
Maybe it would be good to add a page about functions in Calc in our wiki (not only one page )
Jacqueline |
|
Back to top |
|
|
|