Importing an Excel file

[gerard]

Hi

Using Catalog 6:

I've been given an excel file by a client (selling wine) with the following columns on it:

Section Text (the area the wine is from)

Description (the product name)

Cases (number in stock)
Bottles (number of bottles in stock if there’s less than a case)

Price

Vintage (the year it was produced)
Size (bottle size where applicable, otherwise 750 ml)
Each / case (whether price is for a bottle or a case)
Status (duty paid or in bond)
RP – Robert Parkers score (a wine critic giving marks out of 100 where applicable)

My problem is that I would like to import most of these columns (from vintage down) to combine as a description.

My other problem is that I know next to nothing about Excel files, but have the better part of a thousand separate products on this sheet, so I’m guessing that some way of adjusting the excel file before import would be the way forward.

Is there some way of doing this and avoiding manually imputing all this info?

TIA

Gerard

[garyhay]

You need to use the Excel function CONCATENATE.

If you are not sure e-mail the file to me. Address in profile

[gerard]

sorted by email - many thanks!

[garyhay]

="The vintage of the product is "&B6&". The liquid volume is "&F6&". It is sold by the "&I6&". The duty status of this item is "&J6&" and its Robert Parker score is "&K6

Is how I wrote the excel function.

&B6& is replaced (as are the others) wit the the cell data. The text included in " " is just typed into the formula bar