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.

On Mon, 3 Nov 2008 03:36:10 -0800, sinu wrote:

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.

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

What differentiates the mobile and wiredline numbers ? This is different
in most countries..


--
Pecoflyer
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24416

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

"Ron Rosenfeld" wrote:

On Mon, 3 Nov 2008 03:36:10 -0800, sinu wrote:

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.

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

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

thank you

"Pecoflyer" wrote:


What differentiates the mobile and wiredline numbers ? This is different
in most countries..


--
Pecoflyer
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24416

On Mon, 3 Nov 2008 04:08:01 -0800, sinu wrote:

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

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

On Mon, 3 Nov 2008 04:11:00 -0800, sinu
wrote:

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

thank you

"Pecoflyer" wrote:


What differentiates the mobile and wiredline numbers ? This is different
in most countries..


--
Pecoflyer
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24416