Hmm, sorry. It's kinda working.

=IF(ISERROR(RIGHT(LEFT($A2,FIND(CHOOSE(COLUMN()-1,"ca","do","ch"),$A2)-1),3)),0,RIGHT(LEFT($A2,FIND(CHOOSE(COLUMN()-1,"ca","do","ch"),$A2)-1),3))

In the first column of the formula (cell B2), if there is a 3+ digit figure
for cats, it's not showing the first character. Similar in C2, if there is a
single digit, it shows a space in the front of the number, and doesn't show
the first digit of any 3+ digit numbers.

Any suggestions or alternatives?

Meanwhile, I'll try and nut this formula out! :)

Thank you!
Lauren