Discussion Locked

Display only numbers from Excel cell

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Excel spreadsheet with cells containing both letters and numbers. However I wish to strip out only the numbers from the cell. Does anybody know if there is a function within Excel which will do this ?

5 replies

by dklippert

If there are a specific number of letters, it's easy. Click on the Paste Function icon (Fx) and look for the Right, Left, Mid and or Len functions.
For instance if you have a part number ABC999,
The forumula may be
=VALUE(RIGHT(A1,LEN(A1)-3))Len determine how many characters in the string
subtract 3 for the letters and take what ever remains.
Value converts the text to numbers.

by jean_hera

You need to be more specific with what is on your cells.
What was proposed in the previous answer holds if in general your cells have values like this:
acbdefxxxxx where x represents a number from 0-9
however if your cell have a mixture like this:
acbxxxdefxxxabcxxx that would not help.
Is there a patern? can you astablish one? if not give an example of what in your cells.

This discussion is closed to new replies.