+ Reply to Thread
Results 1 to 2 of 2

Formula to isolate part of text in a list of emails

  1. #1
    Registered User
    Join Date
    05-17-2021
    Location
    UK
    MS-Off Ver
    2016 / O365
    Posts
    4

    Formula to isolate part of text in a list of emails

    Hello,
    I have a long list of emails, most of which end in a standard .com format, but others end in a different format, e.g. .be or .ch

    I'd like, in a new column, to extract the company name, i.e. everything between the "at" and the first 'dot' after the "at" (this forum won't let me post the "at" symbol, odd)
    I have tried using the LEFT and RIGHT functions to try and isolate the text between the "at" and the dot, but I can't figure it out. I have also tried text to columns, but as the names are non-standard lengths I can't get that right either.
    Any ideas please?

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,715

    Re: Formula to isolate part of text in a list of emails

    See the yellow banner at top of the page on how to attach a sample workbook.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need a macro that will send an email or emails from a list of emails
    By MassiveJim in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-08-2020, 11:09 PM
  2. [SOLVED] Large string within cell - Isolate text and ninth value after the text, assign to column
    By Tompouce in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-05-2018, 10:47 AM
  3. Replies: 15
    Last Post: 11-28-2014, 07:10 AM
  4. Replies: 1
    Last Post: 05-05-2014, 09:30 AM
  5. [SOLVED] Need a formula to isolate a number from a text string
    By chicolocal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 01:19 PM
  6. Can you use an excel function to isolate part of a text string?
    By CharCat in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-27-2012, 02:05 AM
  7. How do I isolate the Fractional part of a number in Excel VB?
    By Cumulous in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2006, 05:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1