Need to split out the first 5 digits of a string into a new row

lb345

Hi,

I am working on a workflow, and part of it, I need to split out a string, so I can separate out the first 5 digits into a new row. Thanks in advance! For example:

So I only want the first 5 digits of center to be split into a new row.

Input
Type	Value
CENTER	1111199999
CENTERName	999TESTTESTTEST
Output
Type	Value
CENTER	1111199999
CENTERName	999TESTTESTTEST
CENTERNEW	11111

jdunkerley79

Something like this might work for you

Use the filter to pick rows you need (just Center in example you gave)

Adjust the values with formula tools

Finally union back together with original data

Dupe and adjust certain rows.yxmd