I need to prepare a lot of data for upload from Excel to a system. Example, In cell A1: I have very long text that I need to parse into B1, C1, D1, etc, depending on the length as each cells can support up to 40 characters only. It seems easy as I can just find the length of A1 and use mid to parse them to the rest of the cells. But the sales person wants the data to be readable, meaning that I can't just split the data simply based on the character limits.
I have put a sample in the google docs at the link below. Can this be done using worksheet functions or I have to use a macro to do it?
http://spreadsheets.google.com/ccc?k...wVzVjQWc&hl=en
Thanks.
Bookmarks