View Single Post
 
Old 04-07-2019, 03:59 PM
14spar15 14spar15 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Put numbers within a cell into numerical order.

Hello, I’m looking to keep this data in its own cell but in numerical order. In other words, If I have “1999 2001 2004 2003 2000 2002” in A2 I need to have this changed to “1999 2000 2001 2002 2003 2004” in B2 or whatever depending on how many steps it takes. I was thinking I could put each year into its own column, sort the column and then put it back together but I ran into problems even trying to split the string up. There can be anywhere from 1-20 different years if that matters. Thanks
Reply With Quote