Removing Text from numer field

D

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
 
R

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
Click to expand...

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

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

should work.


--ron
 
Top