As part of my earlier request (with thanks to Claus !), I have another small issue to solve. So again...... if somebody can help me out
In column A Cell 1 till the last, I've got combined text like;
Whats the problem..... (and question).
All the values after name":" and thereafter between the quotes must be copied to the same row column B in a new Cell and separated with ";".
The above in A1 result in B1 then in;
The macro picks up Name":" and takes the text thereafter till the next " copied this to column B and then looks to the next same condition. All found text must be copieed to the same row column B and combining the results with a split ";"
This looks a difficult one ?
I hope for a solution.