I have a spreadsheet that was created with 6 columns, and now after being saved as a csv file, all the data is in 1 column separated by commas. Is there an easy way to convert back to 6 columns?
Thanks
I have a spreadsheet that was created with 6 columns, and now after being saved as a csv file, all the data is in 1 column separated by commas. Is there an easy way to convert back to 6 columns?
Thanks
Select (highlight) the column, then select Data, Text to Columns, and select the options Delimited, and the delimiter to Comma.
hth
Originally Posted by JBasch
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks