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