Sorry evryone the top row of my example should read

A1=abc123 then B1 will=bill

"KeK23" wrote:

I want to insert text into a cell and reference it to text in another cell.

eg A1=123abc then A2 will= bill
A2=456def Then B2 will=john
I have about 20 of the same sets of varying data can anyone suggest any ideas?