G
Guest
I have one field with email addresses, and I want to
extract the email alias (everything before the @ sign in
the address) and populate in another field.
The max characters for the email alias is 8, so in the
field i'm populating, I used the LEFT function to extract
the 1st 8 characters in email address field.
Example: =LEFT(E2,8)where E2 is the email address field
"(e-mail address removed)". In this example, the alias field
would be populated with "username", which is fine, but if
I have an address of (e-mail address removed), the populated field
would have user1@em, which is the 1st 8 characters, but
no the email alias.
Is there a way in the LEFT function to have it search for
8 characters to the left of a particular character in a
field's string, instead of just taking the 1st characters
in the whole field?
extract the email alias (everything before the @ sign in
the address) and populate in another field.
The max characters for the email alias is 8, so in the
field i'm populating, I used the LEFT function to extract
the 1st 8 characters in email address field.
Example: =LEFT(E2,8)where E2 is the email address field
"(e-mail address removed)". In this example, the alias field
would be populated with "username", which is fine, but if
I have an address of (e-mail address removed), the populated field
would have user1@em, which is the 1st 8 characters, but
no the email alias.
Is there a way in the LEFT function to have it search for
8 characters to the left of a particular character in a
field's string, instead of just taking the 1st characters
in the whole field?