# Sorting by first word in column only

#### mjservingjesus

##### New Member
I would like to find a way to sort Alphabetically by only the first word in a column. For example, I have Dilger Ave Apt 324, and I would like excel to sort only "Dilger" and then sort another column "second in line". Right now when I try to sort, it will sort out Dilger, then Ave, then Apt, then number, and only after all that will it go to the secondary column. I want it to simply sort "Dilger" and then the next specified column. Any tips on how to do this? I have only intermediate Excel knowledge so a little explanation on anything complicated would be great. Thank you!

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
If you want to sort by the first word only, try putting a formula in an adjacent column and then sorting by that column
So 2 options would be

1.

Excel 2003
AB
1Dilger avenueDilger
3zebra avenuezebra
4brown placebrown
Sheet1
Cell Formulas
RangeFormula
B1=LEFT(A1,FIND(" ",A1,1))
B2=LEFT(A2,FIND(" ",A2,1))
B3=LEFT(A3,FIND(" ",A3,1))
B4=LEFT(A4,FIND(" ",A4,1))

2.

Excel 2003
AB
1Dilger avenueD
3zebra avenuez
4brown placeb
Sheet1
Cell Formulas
RangeFormula
B1=LEFT(A1,1)
B2=LEFT(A2,1)
B3=LEFT(A3,1)
B4=LEFT(A4,1)

Once completed, delete the unwanted column

Replies
4
Views
193
Replies
19
Views
415
Replies
15
Views
559
Replies
0
Views
198
Replies
6
Views
144

1,203,212
Messages
6,054,190
Members
444,708
Latest member
David R__

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back