| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Separate an email address
Hi,
I have found a formula to separate an email address but would like it to leave the @ =RIGHT(A1,LEN(A1)-SEARCH("@",A1)) For example, this formula takes and returns no.com Is there a way to make it return @no.com Thanks, Bert |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Separate an email address
try
=RIGHT(A1,LEN(A1)-SEARCH("@",A1)) =RIGHT(A1,LEN(A1)-SEARCH("@",A1)+1) -- Don Guillett SalesAid Software "Bert Kinney" wrote in message ... Hi, I have found a formula to separate an email address but would like it to leave the @ =RIGHT(A1,LEN(A1)-SEARCH("@",A1)) For example, this formula takes and returns no.com Is there a way to make it return @no.com Thanks, Bert |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Separate an email address
So close...
=RIGHT(A1,LEN(A1)-SEARCH("@",A1)+1) Add 1 -- HTH... Jim Thomlinson "Bert Kinney" wrote: Hi, I have found a formula to separate an email address but would like it to leave the @ =RIGHT(A1,LEN(A1)-SEARCH("@",A1)) For example, this formula takes and returns no.com Is there a way to make it return @no.com Thanks, Bert |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Separate an email address
Thank you Don and Jim, that worked perfectly.
-- Regards, Bert Kinney MS-MVP Shell/User http://bertk.mvps.org Jim Thomlinson wrote: So close... =RIGHT(A1,LEN(A1)-SEARCH("@",A1)+1) Add 1 Hi, I have found a formula to separate an email address but would like it to leave the @ =RIGHT(A1,LEN(A1)-SEARCH("@",A1)) For example, this formula takes and returns no.com Is there a way to make it return @no.com Thanks, Bert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
| how can i convert an email address to a web address | Excel Worksheet Functions | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| Shut off email address from linking to email program? | Excel Worksheet Functions | |||
Linear Mode
