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