Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Extract company name / domain from email adres (Read 13158 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Extract company name / domain from email adres
14.12.09 at 13:13:13
 
Extract company name / domain from email adres
 
A nice application for the use of the textbetween function is to extract the domain (or usually the company name as is often the case) from an email adres. Since we want the information between the @ symbol and the first . we can use this formula:
 
=TextBetween( A1 , "@" , "." )
 
If A1 contains: jo.blogs@shell.com the formula will give as a result: shell
 
For more information about litlib see:
www.oraxcel.com/projects/litlib
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1