Hi,

Looking for help with the following:

================================
E.g. Column A | B | C

Row 1) John Smith
Row 2) Noah Ava Jones | Liam Mia Jones
Row 3) Jacob Taylor | Sophia Taylor | William Taylor
================================

I need formulas to create 4-digit references on each row.

- The first 3 digits will be 3 letters from the last word (surname) contained in the first column. In the above example, I should have this result: 1) S M I _, 2) J O N _, 3) T A Y _.
- The 4th digit will be a number indicating number of cells containing data within a range. I should have this result: 1) S M I 1, 2) J O N 1, 3) T A Y 3.

Thanks