| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel deleting some numbers from an excel document
I have a spread sheet that has (example) numbers in a cell 45% (5/11) in a
cell or 60% (60/100) in a cell. I have hundreds of cells each with different series of numbers all with a 1-2 or 3 diget % and two numbers in (). I want to delete the number in parenthesis and the parenthesis. I can do it cell by cell but I figure that there should be some way to reformat the cells to do it in mass |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel deleting some numbers from an excel document
=LEFT(A1,FIND("%",A1))
-- Kind regards, Niek Otten Microsoft MVP - Excel "Seth" wrote in message ... |I have a spread sheet that has (example) numbers in a cell 45% (5/11) in a | cell or 60% (60/100) in a cell. I have hundreds of cells each with different | series of numbers all with a 1-2 or 3 diget % and two numbers in (). I want | to delete the number in parenthesis and the parenthesis. I can do it cell by | cell but I figure that there should be some way to reformat the cells to do | it in mass |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting the area code on excel spread sheet phone numbers?? | Excel Discussion (Misc queries) | |||
| change excel document into word document | Excel Discussion (Misc queries) | |||
| convert excel document to word document (not a picture) | Excel Discussion (Misc queries) | |||
| How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
| Help !!! Deleting rows in protected document ?!? | Excel Discussion (Misc queries) | |||
Linear Mode
