Forum Discussion
Splitting Long Text into Different Columns in Excel
I have a challenge that I am hoping to get some assistance with. In Sheet 3 of my Excel workbook, I have a large dataset where the text is in a long format within a single column. I need to split thi...
Parsing logic is not clear, perhaps you may clarify. For example, for Variant
if the part before first space includes dash (-) then Variant = "" and the part before first space goes to first column, etc.