convert cell with text to another cell with number (excel)

[Kwnstantinos_M]

Hello,

In my excel sheet I have a list of text values, namely the first letter of wind directions. So I have something like this:

A	B
SE
NNW
N
N
NNW
S

<tbody>
</tbody>

I want each text ( for instance SE) from column A to correspond to a numerical value. For instance "SE" to 135, "NNW" to 22,5 etc. I need a command which includes all text values and corresponds them with specific numerical values in order to autofill the list B. I tried if command but I didn't make it.. Thank you in advance

 

[Roderick_E]

Hi, how will you know SE is always 135? You would need to build a list then you could reference it with index and match function.

 

[jtakw]

Hi,

Build a Table with All the different values like my sample D1:E4, then you can use VLOOKUP, or INDEX/MATCH suggested by Roderick_E:

Book1
	A	B	C	D	E
1	SE	135		SE	135
2	NNW	22.5		NNW	22.5
3	N	10		N	10
4	N	10		S	180
5	NNW	22.5
6	S	180
Sheet78

Cell Formulas
Range	Formula
B1	=VLOOKUP(A1,D$1:E$4,2,0)

Formula copied down.

 

[Kwnstantinos_M]

Thank you very very much for your immediate answer!! You've saved me!!

 

[jtakw]

You're welcome, welcome to the forum.