Spell out an abbreviation?

[Exc3ln00b]

Need to be able to automate an abbreviation into a full name

Ex: data in column reads” Rn”. Needs to spell out Registered Nurse in a separate column

If another abbreviation is “abc”..
Spell out “ anything but cats”

There would be about ten abbreviations I would need to program to automate written out

 

[keithmct]

VLOOKUP should work. Somewhere else in your sheet, say M1:N10 type a 2 column table: first column with the abbreviations, 2nd column with what they expand to.
If "rn" is in A1 and you want "Registered Nurse" in B1, then formula in B1 is
=VLOOKUP(A1,$M$1:$N$10,2)
and copy that formula down wherever it needs to go

 

[Exc3ln00b]

Bump. Above formula did not work fully

 

[keithmct]

please specify what error. Can you could post a copy of your range? see XL2BB addin

 

[keithmct]

Book1
	B	C	D	E	F	G
3	input		result		lookup table
4	1		one		1	one
5	2		two		2	two
6	3		three		3	three
7	4		four		4	four
8	5		five		5	five
9	6		six		6	six
10	7		seven		7	seven
11	8		eight		8	eight
12	5		five		9	nine
13	7		seven
14	9		nine
15	2		two
16	5		five
17	3		three
18	6		six
19	1		one
20
Sheet1

Cell Formulas
Range	Formula
D4:D19	D4	=VLOOKUP(B4,$F$4:$G$12,2)