Change Column Names in Excel to Text

9 views (last 30 days)
I have an excel file:
California Texas Florida
123 333 234
222 567 123
234 324 334
I want to CREATE or write to a text file with the change column names but yet keep the same data.
So the desire output is:
CA TX FL
123 333 234
222 567 123
234 324 334
Thanks, Amanda

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 15 Feb 2013
Edited: Azzi Abdelmalek on 15 Feb 2013
y= {'California' 'Texas' 'Florida'
[123] [333 ] [234]
[222 ] [567] [123]
[234] [324 ] [334]}
h={'CA' 'TX' 'FL'}
y(1,:)=h

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!