Forumula help to extra characters from a cell

WWARRIOR2018

Morning

I am hoping someone has an idea how I can achieve the following

I have a barcode which is formatted like this when scanned into Smartsheet

(01)00843997014755(11)240401(21)700040293

What I need for example is when the barcode is scanned into lets say cell A, then automatically cell B,C and D will extra data from this cell

Cell B = Everything between (01) and (11)

Cell C = Everything between (11) and (21 )

Cell D = Everything after (21)

Attachment shows the idea final result which I am looking for, I am hoping there will be a formula I can put in each cell to grab this info as I am scanning it

Thanks every for all your help, great community which I have learnt alot from

kowal

hello @WWARRIOR2018

you can use formulas like:

column B: =VALUE(LEFT(A@row, 12))

column C: =VALUE(MID(A@row, 14, 7))

columnd D: =VALUE(RIGHT(A@row, 9))

let me know if it helps.