How to delete the char "A" if it exists?

[Guest]

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

 

[Guest]

=IF(LEN(SUBSTITUTE(A1,"A",""))=LEN(A1),A1,SUBSTITUTE(A1,"A",""))

 

[Guest]

In B1:
=IF(RIGHT(A1,1)="A",LEFT(A1,LEN(A1)-1),A1)

 

[Guest]

Thank everyone very much for suggestions
Eric

 

[Dave Peterson]

Copy column A to column B
Edit|Replace
what: A
with: (leave blank)
replace all

 

[Guest]

=SUBSTITUTE(A1,"A","")

 

[Dave Peterson]

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.