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

Posted on 2014-08-30
Last Modified: 2014-08-30
hi folks,

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

Can anybody help me?  appreciate for your help
Question by:Mandy_
    LVL 10

    Accepted Solution

    First to get the part of the e-mail address before the @ you should use the below formula:

    Open in new window

    Then you can add the domain part as follows:

    Open in new window

    LVL 2

    Author Closing Comment

    Thats it. Thank you so much

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now