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

Limit Column by last 4 characters

I have a contact list that I would like to reference as an office extension list. I have the full contact number in there but would only like to have the last 4 digits show in a particular view.

how do  I accomplish that?
0
sullisnyc44
Asked:
sullisnyc44
1 Solution
 
TracyVBA DeveloperCommented:
If your list is in column A, then put this in column B

=Right(A1,4)

This will pull out the last 4 characters from the right of the value in cell A1.
0
 
sullisnyc44Author Commented:
I am sooooooooooooo sorry - I posted this in the wrong section! I meant to post this in Sharepoint!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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