Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete the char "A" if it exists?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete the char "A" if it exists?
=IF(LEN(SUBSTITUTE(A1,"A",""))=LEN(A1),A1,SUBSTITU TE(A1,"A",""))
-- Gary''s Student "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 |
#3
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete the char "A" if it exists?
Thank everyone very much for suggestions
Eric |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete the char "A" if it exists?
Copy column A to column B
Edit|Replace what: A with: (leave blank) replace all 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete the char "A" if it exists?
=SUBSTITUTE(A1,"A","")
"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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete the char "A" if it exists?
Just to piggyback on Teethless mama's response:
=substitute() will return text and it looks for an exact match (case-wise). =--substitute(a1,"A","") will remove the uppercase A and return that value as a number =--substitute(upper(a1),"A","") will remove upper or lower case A's and return a number. Teethless mama wrote: =SUBSTITUTE(A1,"A","") "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 -- Dave Peterson |
Reply |
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) |