extract last 6 characters in a string

C

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
 
D

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 [email protected] would be screwed up that way.
 
Top