converting txt to xlsx

Hi I am trying to convert a textfile to xlsx. file

My textfile holds this information:

StudentName: James

School: University of Blah

Year: 2020

Grade: 3

Pin: 40

And I want to convert this to xlsx. file

*check the attached screenshot file*

Answer 1

[Tim Koopman]

This will convert the full text file to .xlsx:

yourFileName = readcell('yourFileName.txt')
writecell(yourFileName,'yourFileName.xlsx')

If you only want to save the second column, like in your screenshot, use this:

yourFileName = readcell('yourFileName.txt')
writecell(yourFileName(:,2),'yourFileName.xlsx')

[gmltn1212]

does readcell() function work on text files?

[Tim Koopman]

Yes it does