You need to sign in to do that
Don't have an account?
Ellsa James
Formula to pull an email address from a text area field
I am trying to pull an email address from the standard "Description" field on Cases object. The below formula is correctly pulling everything AFTER the "@" symbol in the email address, (for example "@sample.com").I cannot get it to pull the first part of the email address.
Here is the formula I am using
All help much appreciated.
Here is the formula I am using
SUBSTITUTE( Description ,RIGHT(Description, FIND("@",Description))+ LEFT(Description, FIND("@",Description)), NULL)
All help much appreciated.
or you could use a much less effecient method like:
If it is true I am afraid it is not possible via formula field.
You need to use something similar to text field and to update it from trigger.