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