HELP on "left","right","find","len","substitute" functions
Nel post
*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
|