|
The following directions will allow
you to convert your CompuLEAD sales lead data from UPPERCASE to
Title Case.
Step One
- Import
Into
Excel:
- Open
Excel
- Click
File Menu, click Open.
- Change
to location of your file - directory or drive (i.e.: A:).
- Change
“Files of Type” to Text Files (.txt).
- Select
your file, click Open.
-
The
Text Import Wizard will open (3 Steps).
-
Verify DELIMITED is checked, click
NEXT.
-
Uncheck TAB, check COMMA (text will fall into columns
in the preview window), click NEXT.
-
Using
the scroll bar, scroll the preview window all the way to the
right. Press and hold down the shift key. CLICK on
the last column in the preview window. This should
turn all the columns black. Change "Column data format" to
"Text", click FINISH.
-
Click
File Menu, click Save As.
-
Change
"Save as type" to Text (tab delimited), click Save.
-
Change
the name of the file to something other than the original
file, remember this name.
-
When
a gray box pops up ("...may contain features..."), click YES.
-
Close
Excel - DO NOT save changes.
Step Two - Import Into Word - Change Case
- Open
Word.
- Click
File Menu, click Open.
- Change
“Files of Type” to All Files.
- Select
your file, click Open.
- Hit
Ctrl A (this selects all the text in the document).
- Click
Format Menu, click Change Case.
- Select
Title Case, click OK.
- Click
File Menu, Save As, change "Save As Type" to Text
File (.txt), click Save.
|
