cvs to xls and add colums

[QuestionMan]

I have a database in .cvs and want to convert to .xls. From my experience
can easily been done through the 'Save as" function.

More important, need to adjust the columns of data. Example, in .cvs the
name (first and last) is in 1 column (A) separated by columns and the
city/state are also in 1 column.

Need to break these apart as want separate column for each - last, first,
address, city, state, zip for mail merge and printing envelopes properly.

Did this long time ago and forget the process. Something with copying data
in .cvs to a word doc, replacing all the commas (which in the .cvs separate
the name and city/state) with a period, save to Notepad and open in Excel.
But can't get it right this time. Plus the database is huge and won't open
into Word - have to do it bit at a time.

Any easy way to get this done? Much appreciated.
--
Paul

[Gord Dibben]

Try opening the *.csv file directly in Excel then parse the data using
Data>Text to Columns>Delimited by comma.


Gord Dibben Excel MVP



On Fri, 23 Dec 2005 12:23:02 -0800, "QuestionMan"
<QuestionMan@discussions.microsoft.com> wrote:

>I have a database in .cvs and want to convert to .xls. From my experience
>can easily been done through the 'Save as" function.
>
>More important, need to adjust the columns of data. Example, in .cvs the
>name (first and last) is in 1 column (A) separated by columns and the
>city/state are also in 1 column.
>
>Need to break these apart as want separate column for each - last, first,
>address, city, state, zip for mail merge and printing envelopes properly.
>
>Did this long time ago and forget the process. Something with copying data
>in .cvs to a word doc, replacing all the commas (which in the .cvs separate
>the name and city/state) with a period, save to Notepad and open in Excel.
>But can't get it right this time. Plus the database is huge and won't open
>into Word - have to do it bit at a time.
>
>Any easy way to get this done? Much appreciated.

[QuestionMan]

Thanks. SInce the post was browsing some other posts similar to mine and
found the "data>text" angle to work. Still requires some fiddling but that's
due to the original database.

Thanks again - wish I remembered to come to this board sooner!
--
Paul


"Gord Dibben" wrote:

>
>
> Try opening the *.csv file directly in Excel then parse the data using
> Data>Text to Columns>Delimited by comma.
>
>
> Gord Dibben Excel MVP
>
>
>
> On Fri, 23 Dec 2005 12:23:02 -0800, "QuestionMan"
> <QuestionMan@discussions.microsoft.com> wrote:
>
> >I have a database in .cvs and want to convert to .xls. From my experience
> >can easily been done through the 'Save as" function.
> >
> >More important, need to adjust the columns of data. Example, in .cvs the
> >name (first and last) is in 1 column (A) separated by columns and the
> >city/state are also in 1 column.
> >
> >Need to break these apart as want separate column for each - last, first,
> >address, city, state, zip for mail merge and printing envelopes properly.
> >
> >Did this long time ago and forget the process. Something with copying data
> >in .cvs to a word doc, replacing all the commas (which in the .cvs separate
> >the name and city/state) with a period, save to Notepad and open in Excel.
> >But can't get it right this time. Plus the database is huge and won't open
> >into Word - have to do it bit at a time.
> >
> >Any easy way to get this done? Much appreciated.
>