LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rename imported MS Access field names Ron Excel Discussion (Misc queries) 1 May 7th 09 05:17 PM
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET r.kordahi Excel Discussion (Misc queries) 2 January 3rd 09 08:10 AM
Make words imported into numbers, ex SMRC=303 mulligbo Excel Discussion (Misc queries) 2 October 31st 06 10:03 AM
How do I add imported data with a - sign after it to make it add . Eileen White Excel Discussion (Misc queries) 2 May 18th 06 08:01 PM
How do I make a graph of the frequency names come up in a column? gziomek Charts and Charting in Excel 3 December 28th 05 11:55 PM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"