An application I use exports strings of data in an array in one cell, like so:
"data1"= value1; "data2"= value2; "data3"= value3; "data4"= value4; "data5"= value5;
I'd like an equation or macro or something that could split it like this:
Is this possible?![]()
Please Login or Register to view this content.
Excel 2003 on Windows XP
Bookmarks