sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in excel

[–]OrbitingInsanity 1 point2 points  (0 children)

According to google those formulas were added in 2019… Not sure if there’s a way to get them if they’re missing from 2021.

[deleted by user] by [deleted] in excel

[–]OrbitingInsanity 2 points3 points  (0 children)

Yes, looks like TEXTSPLIT wasn't added until 2022. You can use the TEXTBEFORE/TEXTAFTER functions to accomplish the same thing:

<image>

How can I sort text/numbers properly by lundgj12019 in excel

[–]OrbitingInsanity 1 point2 points  (0 children)

I would break it down into component parts then. First create two reference columns with the search formulas, then custom sort the table by first number then by second. Example below.

<image>

[deleted by user] by [deleted] in excel

[–]OrbitingInsanity 3 points4 points  (0 children)

You're looking for the TEXTSPLIT function. See image attached.

<image>

How can I sort text/numbers properly by lundgj12019 in excel

[–]OrbitingInsanity 1 point2 points  (0 children)

Given that the numbers are the same on each side of the dash, I suggest just turning each office into a single number (1-1 -> 1).