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

If the addresses are consistent with a number
in front as the first word, you can use
SEPTERM macro at
Separate first word (term) from remainder of cell (#septerm)
http://www.mvps.org/dmcritchie/excel/join.htm#septerm

A worksheet solution is also provided, but it requires the original
plus two more columns, and then requires clean up later. The macro
simply requires the addition of an empty column to the right.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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

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