| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing select informaion from cells
I have columns with numbers and symbols in. They look like this:
456456* 521369* 789456! I have highlighted the column and i want to remove any numbers in the cells but keep the symbol in the cell. I tried shift and F but i couldnt get it to do this for any number that appears in the cell, i found i had to type in the specific no then it would work. This is too time consuming, I have alot of columns! Any help will be appriciated. Thanks, -- Susan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing List from Cells | Excel Discussion (Misc queries) | |||
| Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
| Removing spaces from cells not possible? | Excel Discussion (Misc queries) | |||
| Removing $$ Reference in cells | Excel Worksheet Functions | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Threaded Mode
