• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

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,
0
shland
Asked:
shland
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
=right(a1,5)
0
 
NBVCCommented:
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now