extract last 6 characters in a string

[cathal]

I have 100's of e-mails with the tag "-E0030" (or some variant of this)
My question: how can I extract the last 6 characters (including th
hyphen) from my string?

many thanks - catha

 

[Frank Kabel]

Hi
try
=RIGHT(A1,6)

 

[Dave R.]

To "extract" the final 6 characters you can use =RIGHT(A1,6)

However it sounds like you might want to get rid of those characters from
email addresses, in which case you can try
=LEFT(A1,LEN(A1)-6)

Or go to DATA>text to columns> delimited and select "-" as a delimiter;
although any emails like (e-mail address removed) would be screwed up that way.