truncating data within a cell for an entire column

[Guest]

Hi,
I have a numeric value in a cell that is followed by a space and then three
alphanumeric characters e.g., -24 dBm. How can I delete the alphanumeric
chracters and preserve the nummeric charaters so that I can apply the average
function to the entire column?
Thanks,
vlapi

 

[gls858]

Hi,
I have a numeric value in a cell that is followed by a space and then three
alphanumeric characters e.g., -24 dBm. How can I delete the alphanumeric
chracters and preserve the nummeric charaters so that I can apply the average
function to the entire column?
Thanks,
vlapi

Try the text to columns feature under the Data menu.
You will need insert a blank column to the right if one doesn't exist.
Its pretty straight forward but if you need more info just post back.

gls858

 

[Gord Dibben]

gls858

Just for info...............

At third step in Text to Columns you can click on any column you don't want
pasted and select "do not import(skip)"

In this particular case it would eliminate the need for inserting a blank column
to the right.


Gord Dibben MS Excel MVP

 

[gls858]

gls858

Just for info...............

At third step in Text to Columns you can click on any column you don't want
pasted and select "do not import(skip)"

In this particular case it would eliminate the need for inserting a blank column
to the right.


Gord Dibben MS Excel MVP

Good point. I usually keep the data just in case. I can always delete
the column later if need be. Just a habit of mine.

gls858