How to Delimit Cells in Formulas

SergeantPup

Hi,

I have two columns:

I want the second column to be delimited (trim) at just the release version. Unfortunately, I'm not super experienced with formulas.

While I was able to get this formula to work for 1 row,

it's easy to see how this isn't scalable. I looked for instructions on trimming and delimiting but all the examples I saw had words that you could filter out.

I tried looking for some wildcard functionality but I couldn't find it. Can someone help me with a formula that will strip everything out of the first column except the last 4 characters for placement in the second column?

AravindGP

Hi There,

You can have a formula in AFO Version and make it a column formula. The formula would be "=Right([Primary Column]@row, 4)". This formula will pick up the last 4 characters of the text in your primary column.

AravindGP

Hi There,

You can have a formula in AFO Version and make it a column formula. The formula would be "=Right([Primary Column]@row, 4)". This formula will pick up the last 4 characters of the text in your primary column.