sorting

C

curious user

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 ?
 
L

Luke M

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot sort a table containing text 5
Sort by placement value from left to right & adding trailing zeros for short 3
Sort Question 1
Sort Issue Excel 2003 1
Phone notification 0
Group & Sort with formulas (HTML) 2
Sorting problem. My header rom is getting sorted with the rest. 1
Remove Identical words 0

Top