Separate the Last 4 or 5 digits from given Address

Question

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.

Separate the Last 4 or 5 digits from given Address.yxmd

TheOC · Accepted Answer

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