Removing Text from numer field

[Dan]

I have a text file that I imported into Excel. The length
for the Amount field sometimes ends w/ a character. Is
there a formula to remove text from a cell?

Dan

 

[Ron Rosenfeld]

I have a text file that I imported into Excel. The length
for the Amount field sometimes ends w/ a character. Is
there a formula to remove text from a cell?

Dan

If it only ends with a single text character, then:

=IF(ISERROR(-A1),--LEFT(A1,LEN(A1)-1),A1)

should work.


--ron