I have two columns of text? first name? and a columns "second name", I
have both columns typed in lower case and would like to have a capital
at the start of each name
Their are app 2 thousand name

Hi armagh,

Follow these instructions to capitalize the names in the two columns:

Create a new column to the right of the existing lower case text.
(Let's assume this will be column C)

In the first cell of the new column, type =proper(xx) where xx equals
the cell reference of the adjacent upper case text to be converted.
For example, if the column of first names begin in cell A1, you would
type =proper(A1)

In column C, select all the cells to the right of the cells that
contain data in column A.

With the same range selected, click Copy on the Edit menu.  

Select cell A1, and click Paste Special on the Edit menu. Under Paste,
click Values, and click OK to paste the converted values back on top
of column A.

Delete column C by selecting the column and clicking Delete on the Edit menu. 

Repeat the same steps to capitalize the list of last names.


I hope this is helpful. If you have any problems or need any
clarification, please don't hesitate to ask for further assistance
before rating may answer.

Best regards,
Rainbow

---

Request for Answer Clarification by armagh-ga on 30 Sep 2006 07:52 PDT

HELLO rainbow-ga I,m SORRY BUT I CAN.T GET IT TO WORK,I think I have
followed your directions (to the best of my limited abilty) but when I
paste and copy I get the message #name?.

---

Clarification of Answer by rainbow-ga on 30 Sep 2006 08:00 PDT

When you click copy and then paste, make sure you select "Paste Special".

See here:
>Select cell A1, and click Paste Special on the Edit menu. Under
Paste, click Values, and click OK to paste the converted values back
on top of column A.

Let me know if you have any more problems.

Best regards,
Rainbow

---

Request for Answer Clarification by armagh-ga on 30 Sep 2006 08:45 PDT

I?M STILL NOT GETTING IT,WHEN YOU SAY SELECT ALL THE CELLS THAT
CONTAIN DATA,DOES THAT MEAN TO HIGHLIGHT OR TO DRAG THE VAULE OF C1
THROUGH ALL THE CELLS TO THE RIGHT? SORRY ABOUT THIS

---

Request for Answer Clarification by armagh-ga on 30 Sep 2006 09:14 PDT

Just to let you know what I am doing, I think I am following your
directions but must not be. the spreadsheet I have has nine columns
populated. Columns e&f have the info I need changed I created a new
column between e&f, put in the term =proper (e1)

---

Clarification of Answer by rainbow-ga on 30 Sep 2006 10:30 PDT

I'm glad it worked in the end.

Thank you very much for the rating and tip.

Best regards,
Rainbow

Thanks for your patience’s rainbow, got it to work by copying column
to new page then following your instructions with each column.

Perhaps it's better next time  to describe what steps to take by using
the function menu. =proper() is the english formula. for other
languages the formulas are also translated. In dutch for example the
formula would be =beginletters(A1)

just an idea ....