How to format a list separated by semi-colons

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
  • (Edited)
I need help adding a large number of contacts.  I have a list that was emailed to me that is email addresses only, separated by semi-collins.  I have tried copying and pasting the list into a word document and then saving it as a .CSV file, but that will not work.  I have also tried saving the .CSV file into a .XLS file, but all of the email addresses are put into the first row, separated by columns, which creates issues after the file is uploaded (rather than putting the email addresses in the first column, with multiple rows).  Please help!  Thanks.
Photo of Teevan

Teevan

  • 4 Posts
  • 0 Reply Likes
  • frustrated

Posted 4 years ago

  • 0
  • 1
Photo of Marketing Geni

Marketing Geni

  • 16 Posts
  • 10 Reply Likes
Hey Teevan! Sounds like you just need to get the data on its own row...easiest way is to paste into word and then do a replace all where you replace ; (semi collin) with ^n (shift 6 lowercase n) Once this replace is done each record will be on its own line and can then be put into excel and will appear on its own row. Its my favorite redneck work around :)
Cheers,
Mark
Photo of Josué F. Machado

Josué F. Machado, Champion

  • 76 Posts
  • 49 Reply Likes
My suggestions is to save the list as is into a text (.txt) document. Then you can open a new file in Excel and import the data from the text file into a new spreadsheet (http://grab.by/AiF8) using the semi-colons as delimiters. Hope this helps.
Photo of Brandi Leath

Brandi Leath

  • 531 Posts
  • 67 Reply Likes
I was going to suggest the same thing as MainSpring! I like your idea too Mark I didn't even know you could do that! :)
Photo of Teevan

Teevan

  • 4 Posts
  • 0 Reply Likes
I just realized I said semi-collins :) Thanks so much Mark, this worked!  
Photo of Marketing Geni

Marketing Geni

  • 16 Posts
  • 10 Reply Likes
Yes you did..and I copied you so it is completely your fault. :) Glad it worked for ya!