deleting unwanted numerics from cells in coloumn

  • Thread starter Thread starter sinu
  • Start date Start date
S

sinu

I had to differntiate mobile numbers and wiredline numbers which are there in
the same cells in a coloumn. now i dont require wiredline numbers in the
coloumn how do i delete wiredline numbers from the coloumn? thank you.
 
I had to differntiate mobile numbers and wiredline numbers which are there in
the same cells in a coloumn. now i dont require wiredline numbers in the
coloumn how do i delete wiredline numbers from the coloumn? thank you.
Click to expand...

How do you differentiate wiredline from mobile numbers?

With that information, you should be able to easily set up a filter and get rid
of the one's you don't want. (Data/Filter or Data/Filter/Advanced)
--ron
 
Hi Ron,

how do delete unwanted numerics in the cells of a coloumn. every cell
contains duplicate numerics. i cannot replace as wanted numerics get
eliminated.

thank you
 
to keep it simple, how do i delete unwanted numerics in a cell without
deleting the duplicates in the same cell

thank you
 
Hi Ron,

how do delete unwanted numerics in the cells of a coloumn. every cell
contains duplicate numerics. i cannot replace as wanted numerics get
eliminated.

thank you
Click to expand...

I guess you did not understand my previous response.

But unless you can communicate how you tell the difference between a wanted and
an unwanted numeric, your only other option will be to select the unwanted
numeric's, and then press the <delete> key.
--ron
 
Please post a sample of your data and tell us what you want eliminated.


Gord Dibben MS Excel MVP
 
Back
Top