Hello.
I am using VBA to extract the comments from cells in Column B into the same row in Column G. The string in column G essentially has three main parts each separated by a comma. For example, XX XXX XXXX,YYY YY YYY,Z Z Z Z ZZZ. There are no spaces before or after the comma and each string may be different in terms of content and length.
I now need some magic to separate this string into separate columns. Back to the example:
If XX XXX XXXX,YYY YY YYY,Z Z Z Z ZZZ is stored in G6,
G7 should be XX XXX XXXX
G8 should be YYY YY YYY
G9 should be Z Z Z Z ZZZ
I've used LEFT, RIGHT, and MID before but only when I knew the exact lengths of the desired string.
As always, I'm amazed at the loyalty of our MrExcel members and the overall power of Excel.
Thank you to whoever helps me now and everyone that has in the past.
I love this website!
I am using VBA to extract the comments from cells in Column B into the same row in Column G. The string in column G essentially has three main parts each separated by a comma. For example, XX XXX XXXX,YYY YY YYY,Z Z Z Z ZZZ. There are no spaces before or after the comma and each string may be different in terms of content and length.
I now need some magic to separate this string into separate columns. Back to the example:
If XX XXX XXXX,YYY YY YYY,Z Z Z Z ZZZ is stored in G6,
G7 should be XX XXX XXXX
G8 should be YYY YY YYY
G9 should be Z Z Z Z ZZZ
I've used LEFT, RIGHT, and MID before but only when I knew the exact lengths of the desired string.
As always, I'm amazed at the loyalty of our MrExcel members and the overall power of Excel.
Thank you to whoever helps me now and everyone that has in the past.
I love this website!