Calc Formulae: Specifically, I want to use the first 3 letters in the cell to the right and add the number in the cell to the left

[AlwynP]

I have a list of names in alphabetical order. Each name has a cell with a number. I need the fist 3 letters of their name with the relevant number as their reference.

How do I do that?

[JohnSUN]

Do you mean something like =LEFT(A2;3)&TRIM(B2) or something like =LEFT(A2;3)&ROW()? A sheet with sample data would be much clearer

[AlwynP]

Thanks your example exactly what I wanted.