Learnt to split columns by using text-to-column input tools , formulae tool to trim/remove delimiters and Select tool to remove unwanted columns also to rename the columns with appropriate name as well as resposition the columns by using up/down arrow.