I need help taking a excel sheet which has multiple lines rows, with each row there is a group of data only separated by environmental lines (returns) in each cell in the row.
I’m looking for the correct workflow that would separate each found environmental line in a row to it’s own new row. This would need to be the same for each row item in each column as well as there’s multiple columns that have environmental lines or returns in each row cell.
I’m thinking I need to do a “For Each” in DT If “DT = InStr(str, vbNewLine) > 0” But this although may work is looking for a string. I could do for each object assign.tostring then use the above to work. But I’m trying to find a smooth way to do this. Any help would be appreciated.