ST Alpha - "STIS: Excel formula help... I would like to take the value in B2, which is an e-mail address in the format abc@domain.com and populate E2 with" (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: 153

STIS: Excel formula help... I would like to take the value in B2, which is an e-mail address in the format [email protected] and populate E2 with

Posted by Subversive Apr 1 '11, 09:23

[email protected]

Is this do-able?

Responses:

I have a way (rather convoluted though) that assums @domain.com are not consistent (otherwise just search and replace) - decline Apr 1, 09:29 2
- you could also do =left(a1,find(("@",a1,1)-1)&"newdomain.com" -- nm - zork Apr 1, 09:33 1
  - assuming column A not column B as you mentioned. -- nm - zork Apr 1, 09:35
I think so. need a few minutes to research. -- nm - loosilu Apr 1, 09:26 2
- quick question ... are the domains always the same or no? -- nm - loosilu Apr 1, 09:27 1
  - Yes -- nm - Subversive Apr 1, 09:29
Search and replace? Ctrl f. -- nm - miss amanda phones Apr 1, 09:25 6
- Haha, yes, that would work. Dumb me. -- nm - Subversive Apr 1, 09:29 2
  - oh, I thought you wanted to hard code it. -- nm - loosilu Apr 1, 09:30 1
    - No, sorry, just trying to save myself a bunch of typing. Thanks. -- nm - Subversive Apr 1, 09:31
- what if it's not all the same domains being replaced? -- nm - zork Apr 1, 09:29 1
  - It is. See, this is why I ask you guys, because I would have inevitably done it the more difficult way. :) -- nm - Subversive Apr 1, 09:30
- see?? nm - Dignan Apr 1, 09:27

Post a message top

Replies are disabled on threads older than 7 days.