| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting part of the infomation in a cell
ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will delete all Alpha characters from a string....... Vaya con Dios, Chuck, CABGx3 "Office Lapis" wrote: I have been asked to give a total of all the Liters since 2006. In the excel column there is a quantity using numbers but after the number is (L) for liters. I wanted the total sum of about 2000 rows and cannot get it unless I manually delete all the (L)'s from each cell individually. Is there a way to take out all the (L)'s at the same time or am i going to have to do all the 2000 entries separately. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| Deleting time part of a Date, subtracting dates | Excel Discussion (Misc queries) | |||
| Deleting part of a cell | Excel Discussion (Misc queries) | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
| In Excell - How do you get infomation typed in one cell to appear. | Excel Discussion (Misc queries) | |||
Threaded Mode
