Hi ​@Seth 

Currently we only support Excel Office 2016 formulas. So the TextAfter was applied in Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4

 

We have an Idea post here: https://ideas.nintex.com/ideas/IDEA-I-4293

You can upvote and post on the thread and our Product Manager will be notified and may be able to provide more road map ETA details of a newer office version

sorry for the inconvenience and hope  there is an alternative formula for the TextAfter

Brent

Hi Seth, here’s an Excel formula that you can use instead of TEXTAFTER:

=RIGHT(C2,LEN(C2)-FIND(": ",C2,1))

Hi ​@Chris_Ben,Thanks for your help!

that works for the first row, but subsequent  rows look like this: 

The formula doesn’t update to the next row. I’m thinking there has to be a table field reference. 

Do you know how to update the formula to the next cell? 

Thanks!

Hi Seth,

This is an Excel question rather than a Nintex one but I’d expect you should be able to copy cell D2 and paste into all the rows below that and the formula will update to reference the respective row.

Cheers,

Chris

​@Seth You can use the indirect function, so replace the row reference with something like this to make it dynamically grab the correct row number when using row replication e.g INDIRECT("a"&ROW())