| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extract Text--Hopefully Easy!
i have an e-mail address that I would like to extract the text after the @ sign. Cannot use text to columns. Need a function so that way every time I enter an email address, it will continually be updating instead of actually going through and using the text to columns option each time. Any help would be great! -- rae820 ------------------------------------------------------------------------ rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135 View this thread: http://www.excelforum.com/showthread...hreadid=378561 |
|
#2
|
|||
|
|||
|
=RIGHT(A1,LEN(A1)-FIND("@",A1))
-- Vasant "rae820" wrote in message ... i have an e-mail address that I would like to extract the text after the @ sign. Cannot use text to columns. Need a function so that way every time I enter an email address, it will continually be updating instead of actually going through and using the text to columns option each time. Any help would be great! -- rae820 ------------------------------------------------------------------------ rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135 View this thread: http://www.excelforum.com/showthread...hreadid=378561 |
|
#3
|
|||
|
|||
|
Try this (if the address is in cell A1): =IF(ISERROR(FIND("@",A1)),"Invalid Email",MID(A1,FIND("@",A1)+1,255)) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=378561 |
|
#4
|
|||
|
|||
|
it worked...Thank you soooo much!!! -- rae820 ------------------------------------------------------------------------ rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135 View this thread: http://www.excelforum.com/showthread...hreadid=378561 |
|
#5
|
|||
|
|||
|
it worked...however i was wondering if you could explain *why* it worked??? -- rae820 ------------------------------------------------------------------------ rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135 View this thread: http://www.excelforum.com/showthread...hreadid=378561 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract text from html files | Excel Discussion (Misc queries) | |||
| How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
| EXTRACT TEXT FROM A DATE | Excel Worksheet Functions | |||
| Extract text | Excel Worksheet Functions | |||
| Extract % from text string | Excel Worksheet Functions | |||
Linear Mode
