extract last 5 digits in a excel column

Hi,

I have a column in excel with following format:

Column A
this is a test1 - 12345
this is a test2 - 12456
this is a test3 - 11234
this is a test4 - 13789
.
.

I need to extract the last 5 digits of each row which will be the 5 digit number and put in column B for some data manipulation. How can I do this in excel? is there a forumula you can provide for this?

Thanks,
shlandAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=right(a1,5)
0
 
NBVCConnect With a Mentor Commented:
Try:

=RIGHT(A1,5)+0
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.