Hi, I have a list of data from C1 to C552 that contains the same initial text 'FSAR_SOF-' which is then followed by some values in the format similar to '2.3-018'. How do I sort numerically in regards to the first number, then second and so on. For example, I if I have a list of the numbers
FSAR_SOF-2.3-018
FSAR_SOF-2.1-013
FSAR_SOF-2.3-019
FSAR_SOF-3.5-214
I would want it to sort into
FSAR_SOF-2.1-013
FSAR_SOF-2.3-018
FSAR_SOF-2.3-019
FSAR_SOF-3.5-214
Also, if possible, the back portion of the data can extend to values such as '3.5.1-231' and may have multiple parts such as '3.5-222 (a)' and '3.5-222 (b)'. Is it possible to sort by first criteria and then alphabetically by the values that follow on certain entries?
Bookmarks