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

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)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=571069

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

Vaya con Dios,
Chuck, CABGx3


"pack_card2000" <(E-Mail Removed)>
wrote in message
news(E-Mail Removed)...
>
> 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
>

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


--
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