# Select first 5 characters from another cell

1. ## Select first 5 characters from another cell

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
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!

2. 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 Ross

3. ## Re: Select first 5 characters from another cell

=LEFT(A1,5)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:7C884A92-0FA2-4F4E-8EBA-B90B655B9812@microsoft.com...
> 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
> 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!

4. ## Re: Select first 5 characters from another cell

=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 :-)
------------------------------*------------------------------*----------------

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:7C884A92-0FA2-4F4E-8EBA-B90B655B9812@microsoft.com...
>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
> 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!

5. ## RE: 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
> > 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!

6. ## RE: Select first 5 characters from another cell

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
> 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!

7. ## RE: Select first 5 characters from another cell

=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
> 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!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1