extract last 6 characters in a string

  • Thread starter Thread starter cathal
  • Start date Start date
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
 
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.
 
Back
Top