Dear all,

I am new to Excel Marco with very little programming background. I am asked to do a very simple task from my boss but it would be very time consuming if I cant' figure out this Marco to easy my daily task. Any feedback/input will be appreciated. What I am asked to do is to break the string to different columns whenever there's the "+" sign in the string.

Thanks,

Ric

String column A column B column C column D
AAA AAA
AAA+BBB AAA BBB
AAA+BBB+CCC AAA BBB CCC
AAA+BBB+CCC AAA BBB CCC DDDD