+ Reply to Thread
Results 1 to 6 of 6

HELP on "left","right","find","len","substitute" functions

  1. #1
    Registered User
    Join Date
    06-26-2006
    Posts
    5

    HELP on "left","right","find","len","substitute" functions

    Hi, i have a problem here which i need to use "left", "right", "find", "len" and "substitute" function to solve it.

    How do i use left", "right", "find", "len" and "substitute" function to split these car models into two columns?

    Question:

    Honda Accord
    Toyota Camry
    Mitsubishi Galant
    BMW 3 Series

    Ans:

    1st column:
    Honda
    Toyota
    Mtsubishi
    BMW

    2nd column:
    Accord
    Camry
    Galant
    3 Series

    Thank you.

  2. #2
    CLR
    Guest

    Re: HELP on "left","right","find","len","substitute" functions

    With your data in column A, put this in column B and copy down
    =LEFT(A1,FIND(" ",A1,1)-1)
    and this in column C and copy down
    =MID(A1,FIND(" ",A1,1)+1,99)

    Vaya con Dios,
    Chuck, CABGx3



    in 5c"serene83" <serene83.2a1c0c_1151368502.4853@excelforum-nospam.com>
    wrote in message
    news:solum5t6erene83.2a1c0c_1151368502.4853@excelforum-nospam.com...
    >
    > Hi, i have a problem here which i need to use "left", "right", "find",
    > "len" and "substitute" function to solve it.
    >
    > How do i use left", "right", "find", "len" and "substitute" function to
    > split these car models into two columns?
    >
    > Question:
    >
    > Honda Accord
    > Toyota Camry
    > Mitsubishi Galant
    > BMW 3 Series
    >
    > Ans:
    >
    > 1st column:
    > Honda
    > Toyota
    > Mtsubishi
    > BMW
    >
    > 2nd column:
    > Accord
    > Camry
    > Galant
    > 3 Series
    >
    > Thank you.
    >
    >
    > --
    > serene83
    > ------------------------------------------------------------------------
    > serene83's Profile:

    http://www.excelforum.com/member.php...o&userid=35778
    > View this thread: http://www.excelforum.com/showthread...hreadid=555812
    >




  3. #3
    galimi
    Guest

    RE: HELP on "left","right","find","len","substitute" functions

    Use the following formula to obtain the portion to the left of the space

    =LEFT(A1,FIND(" ",A1))

    and for the right

    =RIGHT(A1,LEN(A1)-FIND(" ",A1))
    --
    http://HelpExcel.com
    1-888-INGENIO
    1-888-464-3646
    x0197758


    "serene83" wrote:

    >
    > Hi, i have a problem here which i need to use "left", "right", "find",
    > "len" and "substitute" function to solve it.
    >
    > How do i use left", "right", "find", "len" and "substitute" function to
    > split these car models into two columns?
    >
    > Question:
    >
    > Honda Accord
    > Toyota Camry
    > Mitsubishi Galant
    > BMW 3 Series
    >
    > Ans:
    >
    > 1st column:
    > Honda
    > Toyota
    > Mtsubishi
    > BMW
    >
    > 2nd column:
    > Accord
    > Camry
    > Galant
    > 3 Series
    >
    > Thank you.
    >
    >
    > --
    > serene83
    > ------------------------------------------------------------------------
    > serene83's Profile: http://www.excelforum.com/member.php...o&userid=35778
    > View this thread: http://www.excelforum.com/showthread...hreadid=555812
    >
    >


  4. #4
    Franz Verga
    Guest

    Re: HELP on "left","right","find","len","substitute" functions

    Nel post news:serene83.2a1c0c_1151368502.4853@excelforum-nospam.com
    *serene83* ha scritto:

    > Hi, i have a problem here which i need to use "left", "right", "find",
    > "len" and "substitute" function to solve it.
    >
    > How do i use left", "right", "find", "len" and "substitute" function
    > to split these car models into two columns?
    >
    > Question:
    >
    > Honda Accord
    > Toyota Camry
    > Mitsubishi Galant
    > BMW 3 Series
    >
    > Ans:
    >
    > 1st column:
    > Honda
    > Toyota
    > Mtsubishi
    > BMW
    >
    > 2nd column:
    > Accord
    > Camry
    > Galant
    > 3 Series
    >
    > Thank you.


    If your data are in column A, starting from A1, enter this in B1:

    =LEFT(A1,FIND(" ",A1)-1)

    and this in C1:

    =RIGHT(A1,LEN(A1)-LEN(B1)-1)

    select B1:C1 and copy down.

    --

    Hope I helped you.

    Thanks in advance for your feedback.

    Ciao

    Franz Verga from Italy



  5. #5
    Ragdyer
    Guest

    Re: HELP on "left","right","find","len","substitute" functions

    Sounds like homework to me.

    Will your teacher mark you down since none of the suggestions here used
    "substitute"?

    Ask for extra credit since the "mid" function was used instead.<g>
    --
    Regards,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "serene83" <serene83.2a1c0c_1151368502.4853@excelforum-nospam.com> wrote in
    message news:serene83.2a1c0c_1151368502.4853@excelforum-nospam.com...
    >
    > Hi, i have a problem here which i need to use "left", "right", "find",
    > "len" and "substitute" function to solve it.
    >
    > How do i use left", "right", "find", "len" and "substitute" function to
    > split these car models into two columns?
    >
    > Question:
    >
    > Honda Accord
    > Toyota Camry
    > Mitsubishi Galant
    > BMW 3 Series
    >
    > Ans:
    >
    > 1st column:
    > Honda
    > Toyota
    > Mtsubishi
    > BMW
    >
    > 2nd column:
    > Accord
    > Camry
    > Galant
    > 3 Series
    >
    > Thank you.
    >
    >
    > --
    > serene83
    > ------------------------------------------------------------------------
    > serene83's Profile:
    > http://www.excelforum.com/member.php...o&userid=35778
    > View this thread: http://www.excelforum.com/showthread...hreadid=555812
    >



  6. #6
    Registered User
    Join Date
    06-26-2006
    Posts
    5

    Smile

    thanks for all the help. This is not a homework, juz something which i found in a book.

+ 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