Excel - remove all characters in a cell/column until a numeric character is found

I have a column that has both text and numbers like this:

Jeff - 28pts

I want to remove the "Jeff - " and just have the "28pts" show in the cell/column.

Also, if the cell/column does not have any numeric characters, I want to just remove all text.

Any help is appreciated--thanks!
saturationAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
Try my formula...

or if the dash is there as a separator, you can use:

=IFERROR(TRIM(MID(A2,FIND("-",A2)+1,255)),"")

when there is no dash, you will get a blank.
0
 
jss1199Commented:
You're looking for MID.

If column A contains

                     A                                                           C                                             D
    ====================       ======================    ==============
1   dfgdgfdgf12345                               D1=MID(A1, 6, LEN(A1))             12345
2   DFGGKJD1234567890ABCD         D2=MID(A2, 6, LEN(A2))             1234567890ABCD
0
 
Saqib Husain, SyedEngineerCommented:
Can you give a few more examples of "with numbers"

and also some examples of "without numbers"
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
NBVCCommented:
Perhaps:

=RIGHT(A2,LEN(A2)-MIN(FIND(0,SUBSTITUTE(A2,{1,2,3,4,5,6,7,8,9},0)&0))+1)

where A2 is first cell to check.
0
 
saturationAuthor Commented:
Here's another example:

C5 (cell/column)
Jeff - 95pts
Michael - 100pts
Stuart - 5pts

I need it to look like

C5 (cell/column)
95pts
100pts
5pts
0
 
saturationAuthor Commented:
Perfect.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.