ExcelBanter - sorting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sorting (https://www.excelbanter.com/excel-worksheet-functions/190690-sorting.html)

curious user

sorting

if you have a column of data that looks like xxxxx.xx.xxxx.xx.xxxxx, how do
you sort on just the first 3 sets of characters: xxxxx.xx.xxxx ?

Luke M

sorting

You could make a second columns with the formula
=LEFT(A2,13) and then sort by that.
--
Best Regards,

Luke M

"curious user" wrote:

if you have a column of data that looks like xxxxx.xx.xxxx.xx.xxxxx, how do
you sort on just the first 3 sets of characters: xxxxx.xx.xxxx ?

All times are GMT +1. The time now is 03:36 AM.