Select first 5 characters from another cell

[Guest]

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!

 

[Bob Phillips]

=LEFT(A1,5)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Leith Ross]

Hello Chris

The worksheet formula would look like this..

=LEFT($D$2, 5

This will return the first 5 characters of cell $D$2

Sincerely
Leith Ros

 

[Ken Wright]

=LEFT(A1,5) will do just that

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Guest]

Thanks! Works perfect!

If the text is in A1 then:

=LEFT(A1,5) should get you the first five characters

 

[Guest]

If the text is in A1 then:

=LEFT(A1,5) should get you the first five characters

 

[Guest]

=Left(A1, 5)

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