To separate both numbers and text with commas in different columns, the best method is Text to Columns Wizard.