[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

How to import emails from txt file to excel?

I have a list of emails that are dumped from contacts to a text file.
There are many emails listed and thee must be an easier way to place these items into an excel file.

"First Name Last Name" <email address>, "First Name Last Name" <email address>,...etc  
some items are just listed as <email address>, <email address>,

How do i take that information running together in a txt file and import it into a excel file so each item is in its own cell?

thanks
0
Admin_Stooge
Asked:
Admin_Stooge
  • 2
1 Solution
 
ryan_johnstonCommented:
What are you exporting them from?
0
 
HainKurtSr. System AnalystCommented:
is this one time job or you need an automation?
0
 
HainKurtSr. System AnalystCommented:
I am using UltraEdit (you can install 45 days trial version)

added this to a new document

"First Name Last Name" <email address1>, "First Name Last Name" <email address2>, <email address3>, <email address4>

Ctrl + R : replace : ", " with "^p"

it produced this

"First Name Last Name" <email address1>
"First Name Last Name" <email address2>
<email address3>
<email address4>

then I can copy paste it into excel and use text to columns

does your input contains "<" & ">" characters as well?

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now