ST Alpha - "help, please: is there an easy way to convert a list of e-mail addresses in excel to just names?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 154

help, please: is there an easy way to convert a list of e-mail addresses in excel to just names?

Posted by b. (aka starrynit) Aug 5 '09, 10:28

the addresses are all [email protected]

i tried the replace function, replacing the @company.com with a space; but it didn't work.

(i also tried replacing in word, but that would have me manually delete the @company.com; and there are hundreds of names.)

Responses:

Are they hyperlinked (i.e. blue and underlined?) Un-hyperlink them first (that is, turn them to text) by... - Mop (still 235lbs... on a good day) Aug 5, 10:41 3
- oh, duh. i did that for my first attempts, but then went back to the original. that may be why some other things didn't work. ok! off i go. -- nm - b. Aug 5, 10:44
- copy range, paste special, text only. -- nm - loosilu Aug 5, 10:42 1
  - (into a new column) -- nm - TFox Aug 5, 10:43
you can also replace @company.com by nothing. -- nm - marcel Aug 5, 10:36 1
- i tried that first, but it didn't like it either. (of course, i likely did it wrong, though.)-- nm - b. Aug 5, 10:38
Do you need first and last name in separate columns? - decline Aug 5, 10:36
Is "company.com" the same for *all* addresses? (nm) - musubi Aug 5, 10:35 3
- yes. -- nm - b. Aug 5, 10:37 2
  - Actually, I just figured a way, where it doesn't matter. - musubi Aug 5, 10:43 1
    - You could combine the formulas into one cell. Of course, Enders Data to text is probably simpler. (nm) - musubi Aug 5, 10:46
You might try "Data->Text To Columns" and then split on the "." and repeat for the "@". -- nm - Ender Aug 5, 10:35 8
- 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
yes. give me a few minutes and I can provide this for you -- nm - zork Aug 5, 10:34
There must be a formula for this. Hmmm. -- nm - con_carne Aug 5, 10:32
assuming all different lengths of character strings, not especially. -- nm - TFox Aug 5, 10:31
"Excel" and "easy" do not belong in the same sentence. -- nm - loosilu Aug 5, 10:30

Post a message top

help, please: is there an easy way to convert a list of e-mail addresses in excel to just names?

Replies are disabled on threads older than 7 days.