I want to remove text from a number.

S

Smyth

I want to remove text from a number. For example I want to remove "M" from
12,888M. The left or right function doesn't work well becuase the number of
characters before the M is not constant.
 
R

Ron de Bruin

characters before the M is not constant
Is the text character always one digit?

Try
=LEFT(A1,LEN(A1)-1)
 
D

Dave Peterson

And if you want it a number:

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

=Left() returns a string.
the rightmost negative coerces it to a number (albeit negative)
the second converts it to positive.
 
Top