Forum Discussion
manipulating data in excel
Hi, I have a csv file where in column A there are IDs, and in column B there are associated data. The data is separated with a semicolon (;). And the hardest bit is if one data point shares the sam...
select comun B and use the text to columns function (using ; as the delimiter), which should separate it out into separate columns. Then, if you still need to change : with | (or anything else), select those columns and use the 'find and replace' function. hope this helps.
.....don't forget to use 'save as' and change document type to an excel format, rather than .csv