decap names from transferred data
PROPER won't work with multiple cells.
=PROPER(C1) in D1 then copy down by double-clicking on the fill handle of
D1
Then select column D and copypaste specialvaluesokesc
Delete column C
Gord
On Tue, 11 May 2010 08:28:05 -0700, Attman68
wrote:
Hi,
I just gave this a try, but I cant' seem to get the formula to apply. I
have a column (C) of names in all caps. In a blank cell, I typed
=PROPER(C2:C112) and then hit enter but it keeps giving me error messages.
Any help? Thanks!
"Gord Dibben" wrote:
Once the data is in Excel it is no longer csv format.
I would use the PROPER function for names.
GORD DIBBEN in A1...............in B1 enter =PROPER(A1) to return Gord Dibben
Gord Dibben MS Excel MVP
On Thu, 19 Jul 2007 11:26:02 -0700, goathead
wrote:
How do I decap names that come across in all capital letters when I transfer
data.
I am usinga csv format.
|