| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete the char "A" if it exists?
In B1:
=IF(RIGHT(A1,1)="A",LEFT(A1,LEN(A1)-1),A1) "Eric" wrote: Does anyone know how to delete the char "A" if the cell exist? for example In cell A1, ="178.6A", then it will display 178.6 in cell B1. In cell A1, ="555.5", then it will display 555.5 in cell B1. Thank for any suggestion Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't delete an image in excel workbook | Excel Discussion (Misc queries) | |||
| I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
| Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
| how do I delete a worksheet from my workbook | New Users to Excel | |||
| Delete row depending on criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
