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