View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
goldtech goldtech is offline
external usenet poster
 
Posts: 3
Default Make first imported CSV row into column names ?

Hi,

Is there a way to make the column names in the first row replace the
A,B,C... in the excel tabs?

I am importing a CSV with the col names in the 1st row. It would be
nice to be able to make the ABCDE... into the corresponding col names
from the csv first row, then delete the first row as it is not really
data but I guess it could be called meta-data.

Can this be done during the import process, or easily in one swoop
after the import?

OR

Is the best practice to make the first row unchangeable and not part
of the data that can be manipulated in the sheet? - seems that would
serve same purpose as what I'm asking above.

Thanks.