answersLogoWhite

0


Best Answer

I would use the left and right functions to split up the address into 2 separate columns and then sort on column 2

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you sort data in Microsoft Excel if the data is an address with numbers in front but want to sort by the street name?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How high do the numbers on Microsoft Excel go?

65,536! 1,048,576 with Excel 2007


Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


What are examples of types of data in Microsoft Excel?

numbers and text


What is Excel on computers?

Excel is a specialized program that manages numbers in various ways. It uses spreadsheets and data to process a large amount of numbers. One enters the data, or numbers, and the program calculates the numbrs in the manner you designate in the program.


Who are the creators of Microsoft Excel?

Microsoft excel was created by Microsoft


How does Microsoft Excel helps in accounting?

It can calculate numbers and set out tables and graphs


What are characters called in Microsoft Excel?

A possible answer is text, numbers, and special characters.


Can you use Microsoft Excel for home finances?

Excel can be used for anything to do with numbers, so that would include home finances.


What is the apple equivalent to Microsoft Word and Excel?

The closest equivalent would be Pages, although it doesn't have quite as many features as Microsoft Word.


How do you launch Microsoft Excel?

Programs->Microsoft Office->Microsoft Excel


What is the spreadsheet program in Microsoft office 2007?

I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.


Definition of Microsoft Excel?

When you create a spreadsheet or workbook then a corresponding file is created on your machine, that file is known as excel file.