Separating strings delimited by commas
I am creating a spreadsheet to manage behavior data for our school. I initially created the spreadsheet on Google Docs. It was working but I could not expand it to full functionality due to the cell and cell with function limits. I imported the spreadsheet into Zoho and I am having one problem. In the Google Docs, I was using the split function to separate strings into multiple columns. For example
H,Jumping on desk,Staff 12,Student 16,Log entry 845
After using the split function I'd have
H Jumping on desk Staff 12 Student 16 Log entry 845
where each component is in its own column. This is the format I need to import the data into our database. How I can I do this in Zoho since the split function doesn't seem to exist? I would imagine I could write a macro to do this. However, I have no experience writing macros and I am not sure how. None of the macros I searched for worked. Thanks.