SOUNDEX

Translates a string expression (usually names) into a Soundex code - a 4 digit code consisting of 1 letter and 3 numbers.

The most familiar application of Soundex is its use by the US Bureau of the Census to create an index for individuals listed in the US census records after 1880.

Syntax

SOUNDEX(input_string)

input_string - string expression (or the reference to a cells) to be translated.

Remarks

All Soundex codes have 4 alphanumeric characters [no more, no less]

The Soundex Key
1
b p f v
2
c s k g j q x z
3
d t
4
l
5
m n
6
r
no code
a e h i o u y w