How to diffrentiate Text & number from a single cell????

  • Thread starter Thread starter pack_card2000
  • Start date Start date
P

pack_card2000

:( Hi ther guyz............i a have small problem with the execl
sheets...........
my problem is e.g. i have alot of cells with a number and some text in
it........and they both are in one/single cell (e.g. "878 queen st" in
A1)....now what i want is to remove let's say "queen st" from each cell
so that there is only number left in it.....................i cannot
figure out any formula........if there is any..............need help
imediately
 
Assuming your data in A1

If the number is always at the beginning and separated by a space from
the rest of the text you could use this formula in another cell

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