Routine Column Sort is Acting "Funny"

[thankyou]

Hi. Thanks for checking out this post and for your time & help.

So i titled this "Routine Column Sort is Acting "Funny"" because I'm trying to sort a sheet by Column B ("titles") based on values A to Z (since they don't have a "1 thru...."). The problem is as follows:

https://postimg.cc/XZ9HZS6G

I just want to sort the sheet by values in Column B based on the initial number in the title but, as you can see from the attached screenshot, it's sorting "as if" every number has a decimel after the first digit (I figured).

Thanks for your solution. I really appreciate you.

 

[shg]

The column is text, and that's how text sorts. Move the numbers to their own column.

 

[thankyou]

how? the numbers are part of the text. do you mean parse it? ... I was thinking "text to columns" ...what do you think?

 

[shg]

Text to columns with the decimal as the separator would work if there are no other decimals in the string.

 

[thankyou]

Text to columns with the decimal as the separator would work if there are no other decimals in the string.

Worked like a charm. And, actually, that's what I thought to do (use the decimel), but wanted to come back and say thanks, and then I saw we had similar thinking. Great job. And thanks so much.

 

[shg]

You're welcome.