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

  • Thread starter Thread starter pack_card2000
  • Start date Start date
P

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
 
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.
 
Back
Top