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"
wrote in message
news:solum5t6erene83.2a1c0c_1151368502.4853@excelf orum-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