I want to remove text from a number.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
characters before the M is not constant
Is the text character always one digit?

Try
=LEFT(A1,LEN(A1)-1)
 
One way, use Edit > Replace, Replace What, 'M', Replace With, leave blank,
Regards
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I remove text from a number? 4
Faststone Image viewer popups! 2
Removing text from a date 4
Cut the last 20 characters out of a text string 4
How to subtract a number from a Mergefield? 0
Removing characters from a cell (keeping only the numbers) 9
Formula for extracting text formated numbers within ( )'s as numbe 5
truncating text strings of different lengths 7

Back
Top