Split text to columns and transfer to rows VBA

  • Hello Excel Guru people,
    I have a question how to split text from one cell to columns and then multiply the row to number of splited text words.

    It sound complicated so i have attached and example. forum.ozgrid.com/index.php?attachment/67429/

    In first sheet there is text in column C
    this text have a separator "/---; " . Needed word (number) is *********R (the numbers vary but the R and the separator is always there)
    My goal is to split this text in column C to rows with count of this *********R numbers into the next "Result" sheet but for every number to have first the columns with the DFC (in first sheet column A) and then the 9 yellow colored columns.

    In the example file the equal columns are colored in same color.

    Hope my explanation is not too confusing :)

    Thank you in advance for your help,

  • Re: Split text to columns and transfer to rows VBA


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!