| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
truncating data within a cell for an entire column
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do same operation on an entire column and put the data in the col itself | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| Truncating entire worksheet | Excel Worksheet Functions | |||
| Exported File truncating cell data after 255 characters | Excel Discussion (Misc queries) | |||
| Changing entire column data | Excel Discussion (Misc queries) | |||
Threaded Mode
