Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in a file downloaded to excel
I download information from outside sources into a .CSV file, which I
then save as an EXCEL file. The information contains large quantities of text - which in its original format is all caps. Once I download it, or as I am downloading and saving - is there anyway I can format the cells to first letter cap only? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in a file downloaded to excel
You can insert a column next to the one that contains the text that is in all
caps. In a blank cell in your new column, insert the function '=Proper(A1)' (dont use the quotation marks)... You can drag that function down the entire column so that it converts the entire column without you having to retype the formula wach time. After you are done, copy the new column with the corrected text, then 'paste special', 'values' in the same location. This will give you the Proper Cased data in text, not in the the form of the formula you imput. After that is done you can get rid of the original column of all caps data. Sorry if this is too confusing, I was never great at giving directions, I just thought I would try to help. " wrote: I download information from outside sources into a .CSV file, which I then save as an EXCEL file. The information contains large quantities of text - which in its original format is all caps. Once I download it, or as I am downloading and saving - is there anyway I can format the cells to first letter cap only? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in a file downloaded to excel
Excel has UPPER, LOWER and PROPER functions.
e.g. QWERTY in A1 =PROPER(A1) returns Qwerty To do a great many of these at once you could use VBA macro to change the Case. The macro below will change to Proper Case Sub optProper_Click() 'David McRitchie, programming, 2003-03-07 Dim rng1 As Range, rng2 As Range, bigrange As Range Dim cell As Range Application.ScreenUpdating = False Application.Calculation = xlCalculationManual On Error Resume Next Set rng1 = Intersect(Selection, _ Selection.SpecialCells(xlCellTypeConstants)) Set rng2 = Intersect(Selection, _ Selection.SpecialCells(xlCellTypeFormulas)) On Error GoTo 0 If rng1 Is Nothing Then Set bigrange = rng2 ElseIf rng2 Is Nothing Then Set bigrange = rng1 Else Set bigrange = Union(rng1, rng2) End If If bigrange Is Nothing Then MsgBox "All cells in range are EMPTY" GoTo done End If For Each cell In bigrange cell.Formula = Application.Proper(cell.Formula) Next cell done: Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On 11 Apr 2007 12:45:00 -0700, wrote: I download information from outside sources into a .CSV file, which I then save as an EXCEL file. The information contains large quantities of text - which in its original format is all caps. Once I download it, or as I am downloading and saving - is there anyway I can format the cells to first letter cap only? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in a file downloaded to excel
Hi,
No. You do not have keyboard short cut as Shif+F3 as you find in Microsoft Word. You have to use only the function keys =UPPER(cell reference), =LOWER(cell reference) or =PROPER(cell reference). Challa Prabhu " wrote: I download information from outside sources into a .CSV file, which I then save as an EXCEL file. The information contains large quantities of text - which in its original format is all caps. Once I download it, or as I am downloading and saving - is there anyway I can format the cells to first letter cap only? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file downloaded and lost HELP!!!!!!!!!!!! | Excel Discussion (Misc queries) | |||
Security warning when saving downloaded file from Excel | Excel Discussion (Misc queries) | |||
how can i change margins/apperance on a downloaded .txt file? | Excel Discussion (Misc queries) | |||
How to remove commas from a downloaded .dat file? | Excel Worksheet Functions | |||
I have downloaded a .xls document I cant open need file extension | Excel Discussion (Misc queries) |