Finding text

[asjmoron]

Hi There.

I am a bit stuck here.

As below, I am trying to find a way to locate a section of an address and add a comma to it as below. This a very large list and the address are all over the place (the street is just an example) Any help would be amazing!

to simplify this - find all instances of B2 in A:A and replace them with C2

Original What I need to find What I need to do RESULT 1TheStreetAccrington Accrington ,Accrington 1TheStreet,Accrington 1TheStreetAcle Acle ,Acle 1TheStreet,Acle 1TheStreetActon Acton ,Acton 1TheStreet,Acton 1TheStreetAdlington Adlington ,Adlington 1TheStreet,Adlington 1TheStreetAlcester Alcester ,Alcester 1TheStreet,Alcester 1TheStreetAldeburgh Aldeburgh ,Aldeburgh 1TheStreet,Aldeburgh 1TheStreetAldershot Aldershot ,Aldershot 1TheStreet,Aldershot <colgroup><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Thanks in advnace!

 

[asjmoron]

Joe4 you are a legend!

 

[István Hirsch]

If you have, say, Ring street, then you will get "1TheStreet,Accton" as a result for the first 3 cells.

 

[Joe4]

Joe4 you are a legend!

You are welcome!