=Left(A1, 5)

Will grab the feft most 5 characters from Cell A1. Put this in any other
cell that you want...
--
HTH...

Jim Thomlinson


"Chris" wrote:

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!