Separate the Last 4 or 5 digits from given Address

[RPS1992]

Need to learn if I can Separate the Last 4 or 5 digits from the given Address in more short way (like using a single formula).

Please guide.

[TheOC · Accepted solution]

hi @RPS1992 

Yes, you can achieve this within a single formula:

Here i am taking the right 5 digits, and then trimming from the left either a "-", or a " ".

Attached is the workflow.

Cheers,
TheOC

[Qiu]

@RPS1992 
RegEx should do the work.