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

[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

[daddylonglegs]

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)

[CLR]

You have other answers to this question on the Newusers Group..........

Vaya con Dios,
Chuck, CABGx3


"pack_card2000" <pack_card2000.2cfxdg_1155408607.1111@excelforum-nospam.com>
wrote in message
news:pack_card2000.2cfxdg_1155408607.1111@excelforum-nospam.com...
>
> 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
>
>
> --
> pack_card2000
> ------------------------------------------------------------------------
> pack_card2000's Profile:
http://www.excelforum.com/member.php...o&userid=37431
> View this thread: http://www.excelforum.com/showthread...hreadid=571069
>

[pack_card2000]

thanks...........man it workssssssssssssssssssssssssssssssszz...............