+ Reply to Thread
Results 1 to 7 of 7

Select first 5 characters from another cell

  1. #1
    Chris
    Guest

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

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    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. #3
    Bob Phillips
    Guest

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




  4. #4
    Ken Wright
    Guest

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




  5. #5
    Chris
    Guest

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


  6. #6
    Gary''s Student
    Guest

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


  7. #7
    Jim Thomlinson
    Guest

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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