Originally Posted by

**fluxx2** Lately, I have been playing around with the Excel spreadsheet import functions. What I am trying to do is to import both text and numerical values, and then have each text column correspond to each numerical column. For instance:

Let us assume that we have a excel speadsheet:

first column second column

Text A 10

Text B 20

Text C 30

While [text, data] = xlsread('name of spreadsheet') pulls both the text and the numerical value from the excel spreadsheet, it does so assigning "name = A B C" and "data = 10 20 30" Is there a way to automatically assign "A = 10, B = 20, C = 30"?

I apologize if this has been asked before. I have searched far and wide, without finding the answer. The Matlab help file also comes up empty on this.