software

Hi,

I am wondering how i can convert CSV file into formatted excel
document/template. For example, i have a csv file and a formatted excel
template (column A is bold, column B is italic and etc.) file, my question is
that is there a way to open/load the csv file into the formatted excel file
maintaining the excel format? thanks.

Andy

If you open the .csv file it will appear in its own window. You could
then open your template. In the .csv file window, highlight all the
cells (CTRL-A) and click lt;copygt; then click over to your template
window, ensure that your cursor is in cell A1 and Edit | Paste Special
| Values (check), OK and lt;Escgt; - by using paste special, the formats in
your template will remain. Don't forget to use File | Save As to save
the template with a different name.

An alternative is to lt;copygt; all the cells in the template, click over
to the .csv file window, select A1 then Edit | Paste Special | Formats
(check) then OK and lt;Escgt; - this approach will paste the formats over
the data you have just imported (you could use the format painter, as
well).

Hope this helps.

Petethanks, Pete. It really helps.

Andy

quot;Pete_UKquot; wrote:

gt; If you open the .csv file it will appear in its own window. You could
gt; then open your template. In the .csv file window, highlight all the
gt; cells (CTRL-A) and click lt;copygt; then click over to your template
gt; window, ensure that your cursor is in cell A1 and Edit | Paste Special
gt; | Values (check), OK and lt;Escgt; - by using paste special, the formats in
gt; your template will remain. Don't forget to use File | Save As to save
gt; the template with a different name.
gt;
gt; An alternative is to lt;copygt; all the cells in the template, click over
gt; to the .csv file window, select A1 then Edit | Paste Special | Formats
gt; (check) then OK and lt;Escgt; - this approach will paste the formats over
gt; the data you have just imported (you could use the format painter, as
gt; well).
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;

Well, thanks for feeding back, Andy.

Pete