How to diffrentiate Text & number from a single cell????

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?action=getinfo&userid=37431
View this thread: http://www.excelforum.com/showthread.php?threadid=571068

0
8/12/2006 6:45:02 PM
excel.newusers 15348 articles. 2 followers. Follow

2 Replies
305 Views

Similar Articles

[PageSpeed] 23

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" <pack_card2000.2cfx55_1155408310.8494@excelforum-nospam.com> wrote in message
news:pack_card2000.2cfx55_1155408310.8494@excelforum-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?action=getinfo&userid=37431
> View this thread: http://www.excelforum.com/showthread.php?threadid=571068
>


0
8/12/2006 7:11:48 PM
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" <pack_card2000.2cfx55_1155408310.8494@excelforum-nospam.com>
wrote in message
news:pack_card2000.2cfx55_1155408310.8494@excelforum-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?action=getinfo&userid=37431
> View this thread: http://www.excelforum.com/showthread.php?threadid=571068
>


0
croberts (1377)
8/12/2006 8:55:08 PM
Reply:

Similar Artilces: