change ALL CAPS To First Letter Caps 
Author Message
 change ALL CAPS To First Letter Caps

I received a huge datafile I am supposed to import into Access.  The problem is
that the data is in ALL CAPS.  Does anyone know how to change this so it will
be capital letters for each word and the rest of each word in small caps?



Mon, 17 Jul 2000 03:00:00 GMT  
 change ALL CAPS To First Letter Caps

Download one of the neatcode databases at the MSFT website. There are
different ones for each version and each has a few more toys . All have a
routine to do that.
It probably does not apply but make sure your users want this. (been there)

Quote:
>I received a huge datafile I am supposed to import into Access.  The
problem is
>that the data is in ALL CAPS.  Does anyone know how to change this so it
will
>be capital letters for each word and the rest of each word in small caps?



Mon, 17 Jul 2000 03:00:00 GMT  
 change ALL CAPS To First Letter Caps

Generally when I get a file like that - my boss wants it YESTERDAY.  I would
import the file into EXCEL (the one that comes with Office 95) and it has a
function called     PROPER.  I would make a new column.  If your data is in
colum B, the new column would say =PROPER(B2)
That would convert the text in column B to the having the 1st letter of each
word in upper case.
THEN I would import the file to Access.

Quote:
>I received a huge datafile I am supposed to import into Access.  The
problem is
>that the data is in ALL CAPS.  Does anyone know how to change this so it
will
>be capital letters for each word and the rest of each word in small caps?



Mon, 17 Jul 2000 03:00:00 GMT  
 change ALL CAPS To First Letter Caps

it takes about 2 and a half minutes to write that function yourself !!



Thu, 20 Jul 2000 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Change all caps to first letter caps

2. Changing all caps in names to 1st letter in caps only

3. change small caps to big caps

4. Changing all caps to initial caps

5. Small caps changed to large caps when spell checked

6. Cap Letters for First and Last Name Fields

7. Convert caps to upper case for first letter and lower case for the rest

8. How to Cap first two letters in cell a1-a27

9. Cap first letter

10. Make first letter caps only


 
Powered by phpBB® Forum Software © phpBB Group