Just to be complete...
One approach would be to open that file -- and all the text went into column A,
right?
Then select column A
Data|Text to columns
Delimited by semi-colon
and finish up the wizard (specifying any field you need to)
And then save that file as an excel file.
On 06/13/2010 18:14, Bob wrote:
> Hi,
>
> Figured it out.
> Will blame it on old age.
>
> Thanks for help,
> Bob
> -----------------------
>
> On 6/13/2010 5:13 PM, Bob wrote:
>> On 6/13/2010 4:00 PM, Dave Peterson wrote:
>>> Open the file in excel.
>>> Save the file as a .xlsx (or .xlsm if you add macros).
>>>
>>> On 06/13/2010 14:46, Bob wrote:
>>>> Hello,
>>>>
>>>> Using Excel 2007.
>>>>
>>>> I have a .csv formatted spreadsheet I downloaded.
>>>>
>>>> Is there any "straightforward" way to convert this to the normal Excel
>>>> configuration format ?
>>>>
>>>> Thanks,
>>>> Bob
>>>
>> Hi Dave,
>>
>> As always, thanks for help.
>>
>> Heres what part of what the original .csv file looks like:
>>
>> 279;0000-2400;;BLR;Belaruskoye Radio 1;BY;EEu;;1;;
>> 567;0600-0700;;LAO;Lao National Radio;HM;SEA;;1;;
>> 567;0700-0800;;LAO;Lao National Radio;KHM;SEA;;1;;
>>
>>
>> And this is what I have after Saving it in the regular Excel 2007 format:
>>
>> 279;0000-2400;;BLR;Belaruskoye Radio 1;BY;EEu;;1;;
>> 567;0600-0700;;LAO;Lao National Radio;HM;SEA;;1;;
>> 567;0700-0800;;LAO;Lao National Radio;KHM;SEA;;1;;
>>
>> Looks like exactly the same.
>>
>> Also tried other individual Save As as the .xlsx, although I believe
>> that this is the format that it saves in when you tell it to do the
>> regular Excel 2007 Format. It too looks like the second block, with no
>> apparent change from the .csv
>>
>> Would like to try to get the data between the semi-colons separated
>> into their own columns.
>>
>> Any thoughts as to why, or what else I might try ?
>>
>> Best regards, and thanks again,
>> Bob
>
--
Dave Peterson
|
Similar Threads
