Here is an example of a line of text I want to convert to table.
Nick Adenhart 4/9/09 4/8/09 Car Crash
I want the table to look like this (I entered this in manually):
I have Excel 2007.
How might one do that?
Here is an example of a line of text I want to convert to table.
Nick Adenhart 4/9/09 4/8/09 Car Crash
I want the table to look like this (I entered this in manually):
I have Excel 2007.
How might one do that?
I can come up with a couple of ways but I’m sure people with better computer skills will come later and have better ones.
The simplest one of mine: import the text file telling Excel to separate into columns whenever there is a space. This separates Nick - Adenhart - date - date - word - word…
Join the name and lastname in another column with the formula =(namecell&" "&lastnamecell) where namecell and lastnamecell are the actual cells, do the same with the description columns.