If you have a table in sheet say Fullnames, e.g like this
A B
DS Dave Smith
etc.

then you can use =VLOOKUP("DS",Fullnames!A:B;2;False) to return "Dave Smith".

Insted of "DS" you can use cell reference, e.g. C2 containing initials.

Regards,
Stefi

€žEán€� ezt Ã*rta:

What formula should I use to change some initials into names?
For example DS to become Dave Smith?