decap names from transferred data
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.
|