ST Alpha - "You might try "Data->Text To Columns" and then split on the "." and repeat for the "@". -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 154

In response to "help, please: is there an easy way to convert a list of e-mail addresses in excel to just names?" by b.

You might try "Data->Text To Columns" and then split on the "." and repeat for the "@". -- nm

Posted by Ender (aka Ender) Aug 5 '09, 10:35

(No message)

Responses:

Yeah, this is how you do it. First use "@" as the delimiter and that will get you a column with "first.last". - Ender Aug 5, 10:38 7
- it worked! *mwah* thanks so much! (and everyone else, too!) -- nm - b. Aug 5, 10:51 2
  - Nice. I was just about to suggest pasting the list into Word, where you can do Replace characters to tabs, and change the casings to Title Case for - con_carne Aug 5, 10:53 1
    - i had tried word, which i'm more comfy with, first. - b. Aug 5, 10:59
- (assuming every e-mail is in that format. the "@" part will totally work.) -- nm - TFox Aug 5, 10:39
- ok, let me try! (thanks!) -- nm - b. Aug 5, 10:38 2
  - good plan. if you need to recombine then do =a1&" "&b1 -- nm - zork Aug 5, 10:40 1
    - i had planned on giving you a formula that would do everything in one step and be portable from one file to another but this should be easy enough. -- nm - zork Aug 5, 10:41

Post a message top

Replies are disabled on threads older than 7 days.