Cell Inputting

[Supdem]

Hi All
Can anyone tell me if its possible to input some ones initials into a cell and when you hit enter, their full name is displayed instead of the initials:
ie input FB and the same cell displays Fred Bloggs ?

Many Thanks
Supdem

[zbor]

Can you use second column (and, of course, list of predefined initials).

Book1.xls

[Supdem]

Thanks Zbor

I had thought of your idea, but was hoping for the cell itslef to chnage form initals to name. The nearest I could come up with is shown on the attached spreadsheet. It actually does work for large characters ie like C, G, K etc but falls flat on narrow letters like I or J.

So as far as youre aware, is there no way to turn FB into F Bloggs using some form of Vlookup?

Cheers.

[zbor]

You can do something like this perhapes?

Book1a(1).xls

[DonkeyOte]

You can use Defined Names (bad turn of phrase perhaps)

Name: FB
refersTo: F Bloggs

You can then enter

=FB

and it will return F Bloggs

If that's what you mean ?

Else you're looking at VBA (Change Event) to do the LOOKUP calc in memory and return just the result to the cell.

[Supdem]

Thanks Zbor
Interesting, looks useful that, Ive never used that function before, but it still means inputting intials in one cell and the result appearing in 2 others, so at any one time you'll have eg:
FB and F Bloggs
showing on the spreadsheet.

If a function cant do this, do y ou know if VBA could read in the contents of a cell, ie FB, and output F Bloggs to the same cell?

CHeers

[Supdem]

Ahhhhhh! Right Donkeyote, I've got you - there might be some mileage in that, so I'll need one per each name on my list and all my users have to do is put an "=" before their intials!

Cheers, much appreciated.
Thanks also for your help Zbor