View Single Post
  #1   Report Post  
Old March 20th 19, 09:49 PM posted to microsoft.public.excel.programming
[email protected] jmslab@xs4all.nl is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 55
Default Pick up specific marked text (one or more then one) out of a cell andcombine them into another

Dear,

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;

[{"xxxx":356666,"Name":"AA1234"},{"yyyy":356667,"Na me":"BB3896"},{"yyyy":357633,"Name":"CC38901"}]

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;

AA1234;BB3896;CC38901


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.

regards, Johan