Without using other cells, you could just use Data TextToColumns using
SPACE for the delimiter and choosing not to import the columns with
text..........

Vaya con Dios,
Chuck, CABGx3



"pack_card2000"
wrote in message
news:pack_card2000.2cfx55_1155408310.8494@excelfor um-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=571068