Text Field Is 16 Characters But I Only Want To Display The Last 4 Characters

Question

I have a text field that is 16 characters.&nbsp; The first 12 characters are redundant, so I want to build a formula field based on the field that only shows the last 4 characters.&nbsp; Is this possible?

quickbasecoachd · Answer

No problemMark a new formula text fieldRight(trim([my 16 character field]),4)

jeffrogerson · Answer

perfect, thanks.

Forum Discussion

Text Field Is 16 Characters But I Only Want To Display The Last 4 Characters

Related Content

Display Thumbnail Image

Help extracting text between unique character

Extract Text Between 2 special characters

how to count the number of specific characters

Formula checkbox for certain entries over a character limit