I was wondering if there was a way to have a formula where a cell will grab
the first 5 characters from another cell. The reason is that I have a list of
email addresses in an Excel spreadsheet. The username is the first 5
characters from the persons email address. Is there any way to write an
equation that will automatically pull the first 5 characters from another
cell?
Thanks!
Bookmarks