Select first 5 characters from another cell
Thanks! Works perfect!
"Gary''s Student" wrote:
If the text is in A1 then:
=LEFT(A1,5) should get you the first five characters
--
Gary''s Student
"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!
|