Need to eliminate the Ford from "98 Ford"

Smith Ford

New Member
Joined
Jun 10, 2010
Messages
6
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?
 

Some videos you may like

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
Joined
Jun 19, 2002
Messages
63,650
Try

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

Or to return the result as a number

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

doofusboy

Well-known Member
Joined
Oct 14, 2003
Messages
1,325
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
Joined
Jun 10, 2010
Messages
6
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?

Thanks in advance?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,543
Messages
5,529,456
Members
409,878
Latest member
DDhol
Top