ST Alpha - "I have a way (rather convoluted though) that assums @domain.com are not consistent (otherwise just search and replace)" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 153

In response to "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" by Subversive

I have a way (rather convoluted though) that assums @domain.com are not consistent (otherwise just search and replace)

Posted by decline (aka Decline) Apr 1 '11, 09:29

use text-to-column to split the addresses on the @ sign
gives you 2 new columns with left side and right side
in 3rd column put your new right side @newdomain.com
concatenate column 1 and column 3 to get new addr.

Responses:

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

Post a message top

I have a way (rather convoluted though) that assums @domain.com are not consistent (otherwise just search and replace)

Replies are disabled on threads older than 7 days.