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

[serene83]

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.

[CLR]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[galimi]

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

[Franz Verga]

Nel post news:[email protected]
*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

[Ragdyer]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[serene83]

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