isolate number excel

Microsoft Excel 2007
February 11, 2010 at 10:31:32
Specs: Windows XP, 2,75
hi I have big list with 10 digit or see:

1105542529
2101724569

I need to is to isolate all who have 72, 54 or 1105,2101 or other in the list. how do I do that?

1105 54 2529
2101 72 4569



See More: isolate number excel

Report •


#1
February 11, 2010 at 10:58:40
You could split your numbers into the format shown in your example and then sort them:

1 - Select the column with your 10 digit numbers.
2 - Under the Data menu, choose Text to columns...
3 - Select the Fixed Width option and click Next.
4 - In the list that appears in the next dialog box, click between the 4th and 5th digits and then between the 6th and 7th. A vertical line should appear when you click between the digits.
5 - Click Finish
6 - Sort your columns as desired.


Report •
Related Solutions


Ask Question