How do I change alphabetizing in MS Excel to sort quotes and brackets, i.e., tab, [tab], "tab" in that order?

I'm using the spreadsheet to sort keywords and right now every word surrounded with quotes sorts first, then every word with a bracket second, then every word without either 3rd. Here's an example of how it looks now when I sort:

"boat"
"car"
"house"
[boat]
[car]
[house]
boat
car
house

Where what I'm looking for is:

boat
[boat]
"boat"
car
[car]
"car"
house
[house]
"house"

Any ideas on how to do this?

There might be a better way than the following but give it a try.
I added 2 columns and 2 cells (E1, E2). Your original list I put into column A. The 2 new cells have a Open Bracket and a Quote sign.
The formula in B1 is:
=IF(OR(LEFT(A1,1)=$E$2
,LEFT(A1,1)=$E$1)
,LEFT(A1,LEN(A1)-1),A1)

The formula in C1 is:
=IF(OR(LEFT(B1,1)=$E$2
,LEFT(B1,1)=$E$1)
,RIGHT(B1,LEN(B1)-1),B1)

Copy these two formulas down to the bottom of your list.

Tags

　　General - Computers & Internet 　　Software 　　Security 　　Programming & Design 　　Facebook

Related information

Can I install microsoft office 2007 onto a pc using windows XP?

Yes, XP SP2 can have Office 2007 installed. However, there are other minimum system requirements that need to be taken into consideration (such as RAM). In addition, since there are 8 different Off...

If i download a imunchies or any of those magic tricks from limewire, will it make my ipod touch defective?

it depends, i had a friend who did, and it currupted her ipod, and her cousin did it, and his ipod is fine. its a 50 50 chance so i reccomed buying it from hottrix like i did

...

How do I subtract 3% in excel?

=sum(1.08*0.97)

...

I've downloaded an application to my phone to repair my windows 2000 on my iqon lap top?

if the laptop is kinda working you can use bluetooth to copy it accross, with a bluetooth dongle for the pc. However, have you tried going into a DOS prompt and running sysrestore? It works the sam...

Which is the best software that a person can use for web designing and......?

Web designing is a combination of Code,image and animation.. 1. for coding and layout creation Dreamweaver is good 2. for images editing Photoshop/photo paint 3. for animation Adobe Flash If...

Play tracks from one large flac + cue?

I believe you need to get MP3CUE...a plugin for winamp! This should sort your problem.

...

Is there an easy way to select every other row in Excel?

You can easily shade every other row using Conditional Formatting. 1) Format > Conditional Formatting 2) Set Condition 1 to "Formula Is" 3) =MOD(ROW(),2)=0 4) Click Format ...

Computer Guru鈥檚 I need your HELP!!!!?

Search for the lost folder names using the search function in XP (they could have just been moved smoewhere else)...if no provail, try downloading a program called Recuva which can recover deleted ...