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

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

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

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

Thank everyone very much for suggestions
Eric

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

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

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