Changing Data
 

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

Changing Data
 

Use VLOOKUP(). See:

http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200804


"Eán" wrote:

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

Changing Data
 

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?