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