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

 

[David McRitchie]

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.

 

[CLR]

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" <[email protected]>
wrote in message
news[email protected]...