I'm working with a spreadsheet (v2003) with a lotta raw data, and displaying it in a separate worksheet for executive review. The raw data is fairly easy to deal with, except for one cell that has multiple values of 5 characters, separated by commas (e.g. 4ER9G, 22WE9, 24WK7, etc) and I need to parse those into distinct rows, with all the other values of that row of data remaining the same, or all the other cells from that row remaining blank so that the new rows are only comprised of the 5-character values being parsed. Some of the cells contain 1 or 2 values, but some contain 5 or 6, which complicates a way to accomplish this. If you need more information, please let me know. Thanks in advance.