truncating data within a cell for an entire column

V

vlapi

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
 
G

gls858

vlapi said:
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
Click to expand...

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
 
G

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
 
G

gls858

Gord said:
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
Click to expand...

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
 
Top