# Need to eliminate the Ford from "98 Ford"

#### Smith Ford

##### New Member
For example, the cells in my column are like this:

98 Ford
67 Chevy
01 Expedition
etc...

How do I write a forumla to eliminate the Ford, Chevy, Expedition, etc... from each cell?

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### VoG

##### Legend
Try

=LEFT(A1,FIND(" ",A1)-1)

Or to return the result as a number

=LEFT(A1,FIND(" ",A1)-1)+0

#### doofusboy

##### Well-known Member
Assuming your data is in cells A1:A3, you could put this formula in cell B1 and copy it down:

=LEFT(A1,2)

#### Smith Ford

##### New Member
Thanks for the quick reponses.

What is the formula if the number varies. For example, I have a download that comes accross as followes:

\$2155.37 Rocky Mtn Power
\$37.43 Post Register
\$521.36 Call Oil

How do a write a formula to pull the dollars away from the vendor when the download comes in the above format?

#### VoG

##### Legend
My formula should work

Excel Workbook
AB
1\$2155.37 Rocky Mtn Power\$2155.37
2\$37.43 Post Register\$37.43
3\$521.36 Call Oil\$521.36
Sheet1

#### Smith Ford

##### New Member
Fantastic. Thanks so much.

Replies
5
Views
102
Replies
4
Views
53
Replies
9
Views
102
Replies
8
Views
65
Replies
5
Views
56