#### kalpeshkansara

##### New Member

- Joined
- Dec 15, 2016

- Messages
- 43

Where

K = 1

L = 2

M = 3

N = 4

O = 5

P = 6

Q = 7

R = 8

S = 9

T = 0

I need this alphabets in excel formula to get numbers of alphabet which i type in other cell. Or if I type any alphabets in 2 or any pairs that shows same numbers at right side of my typed alphabets in same cell address where i need it.

for example if i need to get numbers in

Fig.1 > 2 digits or 4 digits or may be 10 digits. like "24" or "245" or "2346589710". for this if I type in a specific cell

Fig.2 > "LN" or "LNO" or "LMNPORSQKT" then in result I need to get same numbers as I shown in Fig.1. from Fig.2.

pls explain or reply me formula in excel for this type of needs.

Pls help