How do I sort a list of numbers separated by commas in excel?

Question

I have a list of unsorted numbers separated by comas. Whats the easiest way to sort them by value in excel? I think it has something to do with converting it to a .csv file.

Answer 1

In excel there is a function under called "text to columns" just select the data you want broken up and press "text to columns", a wizard will show up and guide you through the rest



Then copy the row and go to "Paste Special" >>Transpose to get it into colums



Then select the colums and right click >> sort >>



In excel 2007 "text to columns" is under the “data” tab

Answer 2

Comma Separated Values In Excel

Answer 3

I think it will solve your problem .Just follow the steps given below.

Let's say that your data is in A1:A8. Follow these steps:



1) If column B is not empty, create a new, blank column at B.



2) In B1, enter the following formula:



=MID(A1,SEARCH("@",A1)+1,LEN(A1))



3) Copy this formula down to B8.



You now have a column where all the timber lengths are extracted. At this point, you can sort both A and B together by using B as the sort key.



CSV stands for "comma-separated values." It's a file format that is used for interfacing with other types of programs.

Answer 4

1) Insert a column and enter =A1&" "&B1 2) Insert a column beside the street address and use the Text To Columns feature of Excel to separate the street number from the street name. Then select your data and sort on the street name.

Answer 5

Say you wanted to put 23,42 into a cell you could try



'23,42



The single quote mark forces excel to accept the number as text.

Answer 6

wer

Answer 7

DO IT