• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Excel getting part of variable text from a cell build prefix and add suffix

hi folks,

if i have an email-address with variable length in cell B9 for example housecleaner@frog.com or hc@frog.com
and i want to build in B10 from the prefix of B9 and add only other suffix as text like @fish.com
The result in B10 should be  housecleaner@fish.com or hc@fish.com.
It should cut always only the text before the @ in B9 and add @fish.com as text.
I tried different formulas but not getting the result.

Can anybody help me?  appreciate for your help
mandy
0
Mandy_
Asked:
Mandy_
1 Solution
 
John EastonDirectorCommented:
First to get the part of the e-mail address before the @ you should use the below formula:
=MID(B9,1,FIND("@",B9)-1)

Open in new window


Then you can add the domain part as follows:
=MID(B9,1,FIND("@",B9)-1)&"@fish.com"

Open in new window

0
 
Mandy_Author Commented:
Thats it. Thank you so much
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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