3 Replies Latest reply on Aug 5, 2016 9:12 AM by Obi-wan Kenobi

    Find/change on large list of addresses

    wblade

      I hope someone can help out here.  I have to format over 11,000 addresses for a publication in the following fashion:

       

      <<current format>>

      1803156, LAST FIRST, ADDRESS 1, STE 1

      1803157, LAST FIRST, ADDRESS 1, STE 1

      etc...

       

       

      <<need to replace first comma and space with a tab>>

      1803156     LAST FIRST, ADDRESS 1, STE 1

      1803157     LAST FIRST, ADDRESS 1, STE 1

      etc....

       

      Can anyone think of an easy way to do this with find/change or another method?