How to Separate Numbers Using Formula in Excel

[@Gwyned]

i need to learn how to segragate those number ( so it doesnt add new but put my numbers from lowest to higher )

[@exceldemy2006]

Hello @Gwyned, To segregate numbers in Excel from lowest to highest without adding new values, you can use the SORT function. If you want to separate numbers from a mix of text and numbers, you might first need to extract them using formulas like TEXTJOIN or by using the FILTER function. Sort Numbers: Select the range of extracted numbers, then go to the Data tab >> click on Sort Ascending. Alternatively, use the SORT function in a new cell, like =SORT(A1:A10) Regards ExcelDemy

[@Gwyned]

​@@exceldemy2006 what I need also to segregate numbers ex 14566 and in other column name of item I purchased ex mask, and other 13455 boots, I want both columns segregate with correct number- it's for work purchase order

[@Gwyned]

Basically of its 14566 mask and other is 13355 boots - and 13355 move up I want boots from other column move it and be in correct row always

[@exceldemy2006]

Hello @Gwyned, It seems like you want to create a sorted list of purchase orders in Excel, where the numbers are sorted in ascending order alongside their corresponding items. 1. Ensure your data is structured with numbers in one column and item names in the adjacent column. 2. If your data is in cell A1(including headers), you can use the SORT function in another range. In a new cell, enter: =SORT(A2:B4, 1, TRUE) This formula sorts the range A2 based on the first column (the numbers) in ascending order. Regards ExcelDemy

[@Gwyned]

@exceldemy2006 but if it sort the numbers in one column, in other column with names will not follow numbers (order numbers it should ) will it ?