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